Creating the ability to multi-select (Access 2003)

[dawnd3]

Hi there, These seems like it would be an easy task but I have actually never done it so I want to make sure I am headed in the correct direction. Right now, I have a field that you can select just one answer and the client wants to change it to a multi-select box. I guess I want to make sure that what I think I need to do is correct. Do I now create a join table between the main table (Contacts) and the table that has the selection list so that it can now store many values for each contact instead of just one? And when the user selects the multiple values in the box (or check boxes) does it automatically populate the join table just as it now auto populates the contact table with the selection id? Or is there something else I need to do?

Thanks for any insight.

Dawn

 

[PHV]

I'd create a child table having a ForeignKey referencing the Contacts's PrimaryKey.
Have a look here:

http://r937.com/relational.html

You may then have a linked subform in the contacts main form.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Remou]

If you use a listbox, the table will not be automatically populated, you would need to use SQL or such like. However, it may be more appropriate to use a subform. This will allow the user to select each item in a new row of the subform. If the subform appears on the contract form, it should be based on the join table with a combo for the 'item' list and link child and master fields set to contract id - the field will then be automatically populated and need not be shown on the form.