Question Updating New data keeping old

[Rach!]

Hello All!

This is probably a really silly question but....

I cant seem to get my head around something. If you have a database that contains a table of costs for say materials, which are updated say yearly but you want to keep all records inputed at the previous cost without updating them, how do you do this?

So say all new records created yesterday were one price but today all new records i creat i want these as a new cost.

I want to make sure that when i update the costs that the old records are not changed?

If anyone have any invoice databases that they can send me or answer this question i would really appreciate it!



Many thanks

 

[pbaldy]

The most common solution is probably to save the price of an item as part of the invoice. That way updates to the price in the products table don't affect previous transactions.