Hello everyone,

I' m kanda new to this forum. I have searched my question in the forum, but
it returned a million posts. Anyway, in my database, I have three tables, one
table is the partlist, one is customer, and orders. In the order form,
customer places an order, part number will be selected from the partlist,
including prices, revision letters, and some other things. My question is a
month from now, I have to change the price of the part in the partlist, many
of the parts were used in the oder table would be changed too. That would
make the total of the old records changed, and that would throw off the
invoice that was printed before. How can I keep the data in the order table
changed when I change the partlist data, (Prices, revision letter,
description ect...) Please execuse me if my explaination is not very cleared.
Thank you in advance for any help.

Sincerely,

Tran