M
mes
I am trying to set up a database to track many individuals for an event. We
are wanting to capture many different things associated with each individual.
Each individual may fall into more than one category and may be involved in
more than one event. How can I set it up to where I have one record per
individual, but can have a place to list all the categories they fall in and
all the events they will be involved in, without having to make a field for
each category and inserting a yes/no? We will want to be able to query by
category, by event, by individual, etc.
are wanting to capture many different things associated with each individual.
Each individual may fall into more than one category and may be involved in
more than one event. How can I set it up to where I have one record per
individual, but can have a place to list all the categories they fall in and
all the events they will be involved in, without having to make a field for
each category and inserting a yes/no? We will want to be able to query by
category, by event, by individual, etc.