How to search for multiple items in same category in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a recipe database, but need to know just how to sccess all
of the recipes that use multiple ingredients?
 
Huh? Even beans need water and salt along with the beans and so the recipe
uses multiple ingredients.

If you want to be able to enter a list of ingredients and then pull up all
recipes that contain those items we will need to see your table structure.
We need to know in what manner you store ingredients in the database.
 
KARL DEWEY said:
Huh? Even beans need water and salt along with the beans and so the recipe
uses multiple ingredients.

If you want to be able to enter a list of ingredients and then pull up all
recipes that contain those items we will need to see your table structure.
We need to know in what manner you store ingredients in the database.
Click to expand...

In a table entitled ingredients.
 
What is the table structure? Do you have one table for recipe name,
description, cooking time, servings, etc. And another related table with
ingredient, measurement, quanity, and remarks (like packed, sifted, room
temperature, etc.).
 
Back
Top