Form Adding Data to two separate tables

[Danelloc]

I'm Trying to build a database for training employees. I have one table which houses general employee data (name, section, class dates, etc) and a separate table that houses Performance notes on each employee. This second table will have multiple entries and longer entries than the general table, so I have the two separate tables with record ID and employee names connected in relationships (not sure if I set that up correctly.



What I want to be able to do is view an employee record with the general table, but also to be able to scroll through and add records to the performance notes table in the same form.

Is there a clean way to do that?

[mike60smart]

Yes best method is a Main Form based on tblEmployees and a Subform based on tblPerformanceNotes.

You should have a Primary Key field EmployeeID in tblEmployees

With a related field EmployeeID Foreign Key in tblPerformanceNotes

You would link Primary Key to Foreign Key on the Relationships Window and Enforce Referential Integrity.