Multiple Choice Box

[DeanT]

I have a Master table with a field called "project_team". On a form linked to
this table I need a list box which will list 10 names from an "Employee"
table and allow the user to select multiple choices from the list box and
enter the results into the "project_team" field in the master; each choice
separated by a ";".

Is this possible.?

Thanks.

 

[Douglas J. Steele]

While it's technically possible, it's a very bad idea.

In relational databases, each field should be atomic: it should contain a
single value. Storing multiple values in a single field leads to all sorts
of problems when you start needing to query on the individual values.

What you should be doing is creating a second table, and linking the two
tables together. The second table would have one row for each selection made
in the list box.

Note that Access 2007 actually allows multi-value fields, doing essentially
what I've suggested above, but hiding the actual implementation details from
you.