Selecting multiple items in a drop down list or combo box

[xX Longshank Xx]

I am attempting to create a training database for the fire district. I
currently have an employee table and what I would like to do is create a
drill form in which the date, subject, hours, location, and who attended. I
would like to create a drop down list of the employees name from the employee
table with the ability to select more than one employee if necessary to store
the drill information. I need to make the data base this way so I only enter
information for one drill and I can keep track of each employees attendance.
All help is welcome.

 

[John W. Vinson]

I am attempting to create a training database for the fire district. I
currently have an employee table and what I would like to do is create a
drill form in which the date, subject, hours, location, and who attended. I
would like to create a drop down list of the employees name from the employee
table with the ability to select more than one employee if necessary to store
the drill information. I need to make the data base this way so I only enter
information for one drill and I can keep track of each employees attendance.
All help is welcome.

You will need another table. I'd see at least three tables here: Employees
(with the employee ID as a primary key, name, contact information, other
biographical data); Drills, with a DrillID primary key, the date, subject,
etc.; and a third table Attendance with fields for the EmployeeID and the
DrillID. You would use a Subform on either the Employee form or the Drills
form to display who attended what.

John W. Vinson [MVP]