Gary,
There are 2 basic approaches: you can either include Yes/No fields in your
main table or create a detail table on the many side of a one-to-many
relationship. For example, you might have an Employees table, and wish to
capture each role the employee fulfills. One approach is to include the
roles as Yes/No fields in the Employee table:
Employees
----------------
EmpID AutoNumber (PK)
FName
LName
SSN
....
VolunteerFirePerson Yes/No
EntertainmentCommittee Yes/No
UnitedWayVolunteer Yes/No
.....
etc.
Another approach is to create a EmployeeRoles table into which each role is
entered as a detail record.
EmployeeRoles
---------------------
EmpRoleID AutoNumber (PK)
EmpID Integer (FK to Employees)
RoleID Integer (FK to Roles)
This approach is generally preferred, particularly if there are a lot of
roles, because it stores only the actual roles each employee has. On the
other hand, if the number of roles is small, checkboxes are very convenient
for data entry.
Another approach you can take is to use a MultiSelect Listbox, however,
multiple selections will not automatically be entered as detail records. You
must take action with VBA code to insert selected rows as records in the
detail table. A Google or forum search for Multi-Select Listboxes should
give you what you need.
Hope that helps.
Sprinks
