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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top