I'm confused with NorthWind

[DaniBoy]

Ok, am looking at the Order Form, that is made from three queries, Order Qry, Order Details Extended Qry ane Order Subtotal. Now this queries are made from the two tables Orders and Orders Detail and Products. On the Order Detail Table I see that we have a field name UnitPrice and on the Product Table there is another UnitPrice. Why do you have to input Pruduct Unit Price on both tables? It does not make sense to me? Can someone tell me why is this like that?


Thanks
DaniBoy

 

[Shep]

I would assume it's because the calculated or standard unit price of a product is not necessarily the price you will charge all customers for that item.

Hence, the ability to adjust pricing on an order.

Just an assumption, though.

Shep

 

[DaniBoy]

I though the same thing!!

I though that too, but then I tried to duplicate the same senerio and it does not work. If you go to the Orders from on northwind and go to the details you are able to somehow pull the unit price automaticly, How? i have no idea since its suppose to be the unitprice field from Order detail table!!!

I dont know!!!!.

 

[Shep]

In Northwind Orders, the details section is based on a query named Order Details Extended.

When you select a Product ID, the unit price is read from the Products table via a DLookup and inserted into the Unit Price field, which you may then edit.

Look in the After Update event of the Product ID combobox in the detail section of the order form.

Shep