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.