I am trying to develop a database for employee training and my Access skills are a bit rusty.
What I want to do is to have two tables connected.
1)An Employee table to house general data (single records), Employee name, Completed course dates.
2)A Training Notes table to house training notes (multiple records) on each employee.
What I think I need is an append query that pulls up the employees' names from the Employee table and then allows users to fill in the data for the training notes table to add a new record in the Training Notes table.
I have the two table and a relationship between the Employee Table primary key (ID) to a Training Notes foreign key (Employee ID).
I need users to be able to pull up employees by name and add to the Training Notes table. I've tried to create an append query that does this, but I can't pull up the employee records.
Currently, I can't seem to get the Relationship to work properly.
Can someone tell me the best way to go about this?