Add Multiple Employees to a Training

[Voltzwagon]

Hello,



I am working on a database to track all sorts of employee information (certifications, training, etc) and would like to add multiple employees to a training instance at once. For instance, if the employees at a particular office attend a training, I would like to be able to generate a list of employees and then select those employees to associate them to a particular training.

Some background

3 tables: Employees, Emp_Training_Assoc, Training
Emp_training_assoc has 3 fields, EmpTrain_ID (PK), Employee_ID, Training_ID

Currently I have a form set up to generate a training record. Then a command button to move to another form where the association would take place.


Thanks!

[Guus2005]

Nothing wrong with your database design.

Check this out.
It contains three samples databases provided by M$.

HTH