Multiple check boxes

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

Guest

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?
--
 
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.
 
Actually, it sounds as though 3 tables would be required: people, locations
and peoplelocations, which would indicate which location each person
visited.
 
Back
Top