If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple selections from list box
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? |
#2
|
|||
|
|||
Multiple selections from list box
On Thu, 3 Apr 2008 11:12:00 -0700, Dan wrote:
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? 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. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Multiple selections from list box
Thank you. Will do.
"John W. Vinson" wrote: On Thu, 3 Apr 2008 11:12:00 -0700, Dan wrote: 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? 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|