Multiple selections from list box

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a form with combo box to select one person. Now, it looks like I need
a list box to select 2-4 persons and make them part of the record. Can anyone
give me some direction on this?
 
I have a form with combo box to select one person. Now, it looks like I need
a list box to select 2-4 persons and make them part of the record. Can anyone
give me some direction on this?
Click to expand...

You cannot and should not put multiple persons into one field, or into one
record.

If you have a one to many relationship, model it as a one to many
relationship, with a SECOND TABLE containing links to the primary keys of your
current table and the table of people. You can use a Subform to add people to
this table using a combo box.
 
Thank you. Will do.

John W. Vinson said:
You cannot and should not put multiple persons into one field, or into one
record.

If you have a one to many relationship, model it as a one to many
relationship, with a SECOND TABLE containing links to the primary keys of your
current table and the table of people. You can use a Subform to add people to
this table using a combo box.
Click to expand...
 
Back
Top