I have a database used to track employee suggestions. One table contains the employee list, the other contains their suggestions. The 2 are linked by an employee identification number. Here's the issue: the employee list will be updated weekly with department changes, etc. However, the suggestion needs to stay with their original department. So, when I query the suggestion table, I want to see the employee's information at the time they turned in the suggestion, not the current information. How do I "copy" the information from the employee table to the suggestion table when the suggestion is entered. I've created a form to enter the suggestions and would like to select the employee name using a combo and have Access automatically fill in the information from the employee table on dept number etc., but actually store that in corresponding fields in the suggestion table. Thanks!