Basic Table Linking Question

[clickster]

I have 2 tables. One is a list of employees (EMPLOYEES table) and the other is a table with information about each employee (INFO table). I have a form that I use to add new employees to the EMPLOYEES table. After I enter the information into the form and add a record to the EMPLOYEES table, I would like Access to automatically create a record in the INFO table with the employee's name.

 

[elizabeth]

If you mean you have entered the employee name in the employee table and now you want to duplicate that same data in the info table, that isn't the way you normally do it. Normally you link tables based on the ID field and try not to duplicate any data. Then you would create a query that contained the employee name from the employee table and the rest of the info you want from the info table, and base your form on that.