How to select multiple values for a lookup field in Access?

[Sherri]

I have a lookup field for a table in Access. Some of my records meet several
of the values for the lookup field. Is there a way to setup the lookup field
to allow myself to select more than one of the values? For example, I have a
table of Volunteers and a field for "position" to indicate the area in which
they will be working. Some volunteers will work one position one day and
another position another day. I am not able to select more than one value for
this.

 

[Douglas J. Steele]

Lookup fields really aren't recommended. See
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for some of
the reasons why.

And realistically a field in a table should only contain one value, not
multiple. If you really need to associated multiple choices, you should have
a second table, linked to the existing one, with one row in the second table
for each value.