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

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?
 
G

Guest

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.
 
G

Guest

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.

In a table entitled ingredients.
 
G

Guest

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.).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top