L
lsj
I want to create a recipe database, but need to know just how to sccess all
of the recipes that use multiple ingredients?
of the recipes that use multiple ingredients?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KARL DEWEY
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.
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.
L
lsj
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.
K
KARL DEWEY
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.).
description, cooking time, servings, etc. And another related table with
ingredient, measurement, quanity, and remarks (like packed, sifted, room
temperature, etc.).