Selecting multiple items in a drop down list or combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xX Longshank Xx - 23 Jan 2008 02:08 GMT

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.

Signature

Reply to this Message

John W. Vinson - 23 Jan 2008 17:19 GMT

>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
[quoted text clipped - 4 lines]
>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]

Reply to this Message