Multiple selections form either a combo or list box

J

John Z

I would like to select multiple names from a master names
table into a field of another table labeled team members
through a form. Each entry is in the project table is a
separate project and a each project can have 2-5 members
and the members can either be the same or different from
project to project. How can this be accomplished?
 
G

Gerald Stanley

Try creating a Form whose RecordSource is "Team Members"
with the list (or combo) box holding the full list of
master names and make this form a sub form of your Project
form. The link between the Project Form and the Team
Members subform should be the unique prject identifier.

Hope That Helps
Gerald Stanley MCSD
 
Top