Hi there,
DLookup is new to me but from what I understand it is probably my best bet. I have a Products table that has three different prices, Key is ProductID.
Prices: Retail, Wholesale1, and Wholesale2.
Now I have a customers table where the user selects the CustomerType using a combo box. CustomerType: Retail, Wholesale1 and Wholesale2.
Now when the user does up an order he selects the customer from the customers table, customer information is drawn into the Orders form, and selects the product in a subform on the order form from the product table.
What I need help with is getting the right price to draw into a field on the subform called CustomerPrice. This price is based on the product the user picks and the CustomerType. Any help would be greatly appreciated?
Thx. Tina
DLookup is new to me but from what I understand it is probably my best bet. I have a Products table that has three different prices, Key is ProductID.
Prices: Retail, Wholesale1, and Wholesale2.
Now I have a customers table where the user selects the CustomerType using a combo box. CustomerType: Retail, Wholesale1 and Wholesale2.
Now when the user does up an order he selects the customer from the customers table, customer information is drawn into the Orders form, and selects the product in a subform on the order form from the product table.
What I need help with is getting the right price to draw into a field on the subform called CustomerPrice. This price is based on the product the user picks and the CustomerType. Any help would be greatly appreciated?
Thx. Tina