Don't want to change data in related tables

[Tran via AccessMonster.com]

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

 

[Lynn Trapp]

This is one of those situations where I recommend storing data
"redundantly." You need a Price field in your Orders table.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Your Price should not be linked to Order table except for PartNumber and
Description. The Order form needs to only fill from price. So in the
furture new orders will fill from new price.

You could add fields to indicate PriceDate and Active and keep pricing
history.