Old records change
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?