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

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?