Title
Old records change
Post
Extreme newbie, be kind. I have a member database containing names, addresses, employee ID, phone, job descripton, level, etc. I use another database to write records, grievance software for the Union. I have them linked so when I input the employee ID in grievance database it imports the employee information from members database. If an employees information in members database changes I don't want any of the old records in grievance database to change, but they do. How do I stop the old records from changing?
Sounds like you have a dynamic link to the related data rather than a static link. A static link use one method or another to copy the data while a dynamic link (typically implemented by adding fields from the releated table to a layout based on the other table) is a "live" link that changes each time the related data is updated.
Here's a discussion of the two methods. In includes a description of how to implement look ups to get a static link to your data:
Auto Fill