M
Milsnips
i'm sure i should know how to do this, but its been a while with SQL:
i have 2 tables..
1. Pricing
2. Request
Pricing has about 10 records with pricingID being primary.
Request has a field called Price which needs to populate the Request "price"
table with the price values from Pricing..
both tables have pricingID in them as lookup field.
hope u understand clearly enough.
thanks,
Paul
i have 2 tables..
1. Pricing
2. Request
Pricing has about 10 records with pricingID being primary.
Request has a field called Price which needs to populate the Request "price"
table with the price values from Pricing..
both tables have pricingID in them as lookup field.
hope u understand clearly enough.
thanks,
Paul