link the Price with Order Detail

[borgi]

Hello, I have the database where the table Products, Order and Order Detail. I need to price in the table products has been linked in the Order Detail table. To Order detail table actually remembered value. Because if I want to change the price of the product so It recalculated the old order.
When I then entered in the subform, product and would give me a price which in the Products table. Then I could the price of products in the table change but my order would remember the old price.
Something like that has the Northwind database but didnt not find how it works there and I think there can be easy way.




Perhaps I was conceived and hopefully someone can help me.

 

[pbaldy]

The common solution is to save the price in the order details table (in other words, have a price field that table). I use the second method to get it from the products table when choosing the product:

http://www.baldyweb.com/Autofill.htm