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.

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.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"DeanT" <DeanT@discussions.microsoft.com> wrote in message 
news:D62A62B6-A761-43E5-B48E-98584175EB17@microsoft.com...
>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.