keep multi value for unit price

[fido77777]

i have this product table with unit price and order table which contain orders for products
from time to time unit price get changed
i want to be able to keep the old and the new prices
so i can set different unit price depending the date i made the order
that each order use the unit price at the time of the order date

 

[georgedwilkinson]

Yes. Store the price with the order.

 

[fido77777]

thanks for reply
but it is not the case
i made the example like northwind database
i keep the price in product table
but when i make an order
the product price depend on when i make that order

 

[Kiwiman]

Howzit

With Northwinds, the price at the time you make the order is written to the "Order Details" table, along with the product,OrderID, quantity and discount I believe.

 

[fido77777]

yes
you r right
so when i store the order i include the current price with each product
that is right
it was in front of my eyes
thanks for your help
problem solved

 

[fido77777]

George Wilkinson
thanks too
you are right
i didn't understand what you said correctly