How do I have multiple selections in a look up field in access?

[kernalz]

I am trying to build a table and one of the fields requires the user to make
more than one selection from a drop down menu or in a list. I know it is easy
to make it so only 1 is able to be selected but how do you make it for
multiple selections ??

Any help would be greatly appreciated.

 

[Duane Hookom]

Lookup fields are generally considered poor design
http://www.mvps.org/access/lookupfields.htm. Also attempting to store
multiple values in a single field is not a good idea.

Read up on normalization. I think you might need a related table that would
contain one record for each "desired" selection from your multiple
selections.