Hello everyone. I was hoping someone could provide me some Query help.
Let's say I have two tables:
TableMyIngredients (contains one field)
FieldMyIngredients - lists ingredients that I have in my possession
TableDishes (contains two fields)
FieldIngredients - lists all ingredients (in one field

) needed to make the dish
FieldDish - lists the name of the dish
These aren't my actual table and field names, but I thought these would make it easier to explain my situation. Anyway, due to an extreme time crunch when I was asked to create a database for this project, I ended up listing all of the ingredients associated with a dish in one field in
TableDishes. Terrible, terrible design, I know. And I don't really have the option of going back and creating a proper database at this point.
Would it be possible to write a Query that will list all the dishes that I have two or more ingredients for?
For example
If
TableMyIngredients list the following:
FieldMyIngredients
Beef
Carrots
Potatoes
Olive Oil
And
TableDishes lists the following:
FieldDish - FieldIngredients
Beef Stew - Beef, Carrots, Potatoes
French Fries - Potatoes, Olive Oil
Burger - Beef, Bread, Cheese
Mash Potatoes - Potatoes, Butter
I would like for the query to return "Beef Stew" and "French Fries" because two or more of the ingredients that make up that dish are listed in
TableMyIngredients but not "Burger" and "Mash Potatoes" since only one of the ingredients that those consist of is listed in
TableMyIngredients.
Make sense? Thanks in advance for any help.
Cheers,
Ryan