Employee Training Database

[tajerome]

I have 2 tables. I have an employee table, an equipment table, I want to tell Access which equipment an employee is trained on. How would I go about doing this?

Thank You,

Tom

[ItsMe]

A third table could include the respective Primary Key values from "equipment table" and " employee table".

[orange]

Do you want any other info about the training ---when it was done?
Is there only has taken training/has not taken training?

[tajerome]

Yes, it would be nice to know who hasn't taken the training. There are only who has taken a particular model number. Right now I have two tables. An employee table that contains a technicianIdNumber, FirstName, LastName,and Title. I also have an equipment table that contains the ModelName and ModelNumber. How does Access know who took what training & how to link the tables together? Should there be a lookup table?

Thanks Tom

[orange]

ItsMe has given you advice re the table structure.

Employee--->EmployeeHasBeenTrainedOnModel<---Model

Good luck.

[June7]

Determining who hasn't taken training requires a dataset of all possible employee/training combinations. This dataset can be generated with a Cartesian query. Then join that query to the TrainingTaken table by linking on the employee and training ID fields, join type "Include all records from {the Cartesian query name} and only those from TrainingTaken that match".