Locking Entries in a Table

[DDEB]

I have an access database that has 2 tables. Table 1 has employee details: primary key, name, supervisor, etc. Table 2 has employee evaluations. The employee's primary key and name is used in Table 2 to create the relationship. I am running a number of queries based on these 2 tables. The query pulls the employee name and all evaluation data from Table 2. It's pulling the supervisor name from Table 1. What I'm trying to do is have any prior data stay the same if an employees information changes. Specifically if an employee changes supervisors I want any new queries to provide results under the new supervisor, however if I were to look at historical information it would provide results under the prior supervisor. I'm not sure if this is possible but any help would be appreciated!

[June7]

Instead of supervisor info in Table 1, would need another table of records for the the employer/supervisor associations. Required fields would be employee ID, supervisor ID, date start.

Don't repeat employee name in dependent tables.