Calculated fields & time dependent data

[beechclose]

Hi

I have a table called tbl_Products which stores details of available products including current price. I have a second table called tbl_chosen_prod ucts which stores the product id and quantity of the product required. I have written a query which allows the customer to choose their product, enter the quantity and calculates the total cost of the chosen product at the moment and that works fine BUT if I were to update the cost of the product in tbl_Product I do not want the cost of the chosen product to be updated as the customer bought the product at the original price.

As I see it I have 2 options but I can't get either of them to work and there are probably better options! The first I tried was to get the product cost into the chosen product table but I don't know how to do that. The other option is to somehow save the calculated field but I don't know how to do that either!

Any help gratefully received.
Thanks
beechclose

[Rabbit]

You'll want to create a new column that will store the price at point in time if you find you have different prices for each item over time but want to keep track of the old price.