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?