re lookup values

[AlisonHollier]

In my student database I am using looked up values - but sometimes the looked up value changes - if a student moves to a new address.

my question is if I change the looked up value all the records change their data - how can I keep the old data on the old records and only put new data ( new looked up value) on newly created records ie since the date the student moved. should I be using looked up vaLue at all??

thank you for your help

[Fitch]

If you are truly using looked up values, old records shouldn't change when you update the address.

This is why, for example, I typically make customer address info fields in an invoice table. These fields look up the address, zip, etc. from the customer table and then don't change when a customer's address is updated in the customer table.

Can you give us a little more detail? What are the tables? How are they related?

Is it possible that you are displaying related fields and not actually using the "Auto-Enter" > "Looked-up value" option?