Table help

[HOMMER]

I have a table that I record products we order. One table has all the products and everything about them. From a form I select a product (from the product table)and record the # of units ordered and current price from my master products table. This works great, the problem is when I have a new price for a product. If I change the price in the master products table it changes all the past prices to the new price. I need to keep the order table with the old orders
at the old price and any new orders reflect the new price...

 

[PHV]

Either add date validity in the master products table or store in the orders table the current price of the product.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[HOMMER]

How do I store the current price? I am using the table as the list...

 

[PHV]

How do I store the current price?
By adding a new column in the table and storing the price used when you create a new occurrence.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244