Append Query to add table data and create new at the same time

[Danelloc]

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?

[mike60smart]

Hi

You need a Main form based on Employees
With a Subform based on EmployeeTrainingNotes

[Danelloc]

Thank you. I have seen info on sub forms and plan to look into that as well.

However, I'm not sure I have these tables properly connected.

It I have a main form for Employees and a subform for Training Notes, ultimately, where is the information being stored? Do I need a table capturing data from both the main and subform?

[mike60smart]

Hi

You have a tblEmployees and a tblEmployeeTrainingNotes

tblEmployees
-EmployeeID - PK - Autonumber
-EmpFirstname
-EmpLastname
-(Other fields describing the Employee)

tblEmployeeTrainingNotes
-EmpTrainingNoteID - PK - Autonumber
-EmployeeID - FK - LongInteger - Number (Linked to PK from tblEmployees)
-TrainingNoteDate - DateTime
-TrainingNote

[orange]

Often Employee training is related to the position or role they play in the organization or project.
Are you sure you have your requirements/scope properly defined?
Suggest you do a mock up (pencil and paper, other) and get some ideas of the things involved and how they relate to one another.

Consider--who needs what training; when is it required; how will the training be accomplished.....