Receipes within Receipes How to?

M

michael G

I am trying to design a db for receipes with tables for
Source,Receipes,Ingredients etc. My problems is that some receipes have sub
receipes(can have more than 2). Take Apple Pie it would have ingredients of
Apples and Shortcut Pastry(which is a receipe in its self) so would Shortcut
Pastry go in the table of Receipes and would i need a link table that refers
back to table Receipes. Or a sub table with link to Ingredients. any help
will be gratfully received. Michael G
 
S

Steve

Start with this and modify as desired ----
TblSource
SourceID
Source

TblIngredientType
IngredientTypeID
IngredientType Fruit, Dry (Flour and Sugar), Spice, Baking Promoter (Soda,
Baking Powder), etc

TblIngredient
IngredientID
Ingredient

TblTypeOfMeasure
TypeOfMeasureID
TypeOfMeasure (Teas, Tbls, Cup, Oz, etc)

TblIngredientRecipe
IngredientRecipeID
IngredientRecipeName
DateEntered
SourceID

TblIngredientRecipeItem
IngredientRecipeItemID
IngredientRecipeID
IngredientID
TypeOfMeasureID
Quantity


TblRecipe
RecipeID
RecipeName
DateEntered
SourceID

TblRecipeIngredientRecipeItem
RecipeIngredientRecipeItemID
RecipeID
IngredientRecipeID
TypeOfMeasureID
Quantity

TblRecipeIngredient
RecipeIngredientID
RecipeID
IngredientID
TypeOfMeasureID
Quantity

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top