How to connect tables to select items from adjoining tables
Posted on 2011-03-18
I am creating a Food Menu database, in Access 2007 with following tables
tblComponent (Bread, Meat, etc)
tblMealType (Breakfast, Lunch, Snack)
I have all foods listed in tblFood
and food components in tblComponents
Want to create a menu in tblMenu for example:
for 3 separate meals, Breakfast, Lunch, Snack
Each meal type must have 3 - 4 components chosen, ie: Breakfast, must have bread, fruit, drink. So when choosing breakfast, 3 components would appear and from there would choose the food or drink.
An example would be:
on Monday would like to choose a bread component that would allow me to pick from this list:
After selecting the above food would then be able to click another box allowing me to choose a different component for fruit that would list
I am able to connect the entire food table to the tblMenu and choose multiple items there, but not exactly what I am looking for.
The food list can be large, so is there a way to create a small pop-up window to choose from?