I am looking for how to design a db that will allow me to have multiple flags for an event. I use Mastercook, which is a recipe database. When one enters a recipe, he can flag whether the recipe is chicken, pork, beef, breakfast, lunch, dinner, etc. There is no limit to how many flags he can associate with a recipe, so if the dish has both chicken and pork, one would check both of those boxes. I am working on a project that I would like to add a similar function. For each event, I would like the user to be able to flag all state standards that may apply to it. My question is how do I set this up? Do I need a unique field for each one and checking the standard will turn it on? If so, what if there are 100+ standards that could be applied? In the end, I would like to be able to search based on the standards and returned all events that have been flagged with whatever I am searching for. I figure I must be missing how to do this without building a unique field for each. I would appreciate any help with this. Thannks.