Hi, please someone this is the last piece of this project I need to complete...I will try to explain this as best I can. I am using Access 2013, I have a recipe project with multiple one-to-many relationships. The main table in all of them is RECIPE. Child tables are HOLIDAY, SPEC_NEED, COURSE... each one of these child tables are comprised of multiple checkbox columns (yes or no)... I need to filter the RECIPE records based on the selected checkboxes in these child tables..so for example if COURSE.Appetizer is checked and HOLIDAY.Christmas is checked RECIPE will produce the appropriate records. I have no idea how to pull this one off...I am currently using the Options Group design tool and have used a separate Options Group design for each of the child tables... This is the last I need to do to finish this project...Any and all help would be extremely appreciated.
Thanks in advance,
Adam