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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-Select 0
selecting multiple values on list box 2
Access Form - Lock Fields from Editing 0
List box selection into combo box 2
Update Table based on Multiple List Box selections. 3
Copying List box values/selection to a database of sorts 2
Multiple seclect list box 1
'Go to Record' button - simple task but can't get it to work 1

Back
Top