Hi, I have the following structure:
Products 1-M ORDER DETAILS M-1 ORDERS M-1 CUSTOMERS
I have ORDER DETAILS set as a junction table so that many products can be recorded within one order. All is good apart from when i go into ORDERS and create a new order. I click the subform which links to the ORDERDETAILS. I then pick a product number(look up from products table). The problem is this: In the ORDER DETAILS I want to display the unit price of this product simply by picking the product id.
Eventually this would form the basis of an order form where I can pick Product Id and have it display unit price.
So how do I set up an order form with a subform that displays unitprice of product when i pick its name/number from a drop-down box? Do I need to set up queries for this? Help I'm going crazy!!
Any ideas on this one, I'm sure its quite simple!!
Thanks in advance
Products 1-M ORDER DETAILS M-1 ORDERS M-1 CUSTOMERS
I have ORDER DETAILS set as a junction table so that many products can be recorded within one order. All is good apart from when i go into ORDERS and create a new order. I click the subform which links to the ORDERDETAILS. I then pick a product number(look up from products table). The problem is this: In the ORDER DETAILS I want to display the unit price of this product simply by picking the product id.
Eventually this would form the basis of an order form where I can pick Product Id and have it display unit price.
So how do I set up an order form with a subform that displays unitprice of product when i pick its name/number from a drop-down box? Do I need to set up queries for this? Help I'm going crazy!!
Any ideas on this one, I'm sure its quite simple!!
Thanks in advance
