Multiple check boxes

T

thunnus10

I need to create an entry form with check boxes that can be ticked for
multiple locations that a person has visited. For example, when given a list
of 20 locations a person tells me the have been to New York, Chicago, and
Boston. I want a check box for each city to indicate the person has been to
these 3 cities. How do I do this on the form?
--
 
J

JohnFol

Sounds like a simple relationship with the 2 main tables being "people" and
"locations". You then create a linking table to store the places visited per
person
To display this on a form, you would then use a main form (based on people),
and a sub form based on a query that joins the linkign table to places.
 
D

Douglas J. Steele

Actually, it sounds as though 3 tables would be required: people, locations
and peoplelocations, which would indicate which location each person
visited.
 
Top