Receipes within Receipes How to?

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

Guest

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
 
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
Click to expand...

The technical terms is 'Bill of materials' (BOM). See:

http://en.wikipedia.org/wiki/Bill_of_materials
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.
Click to expand...

See:

Graphs, Trees, and Hierarchies
by Joe Celko
http://www.dbazine.com/ofinterest/oi-articles/celko24

"[One] property of a hierarchy is that the same node can play many
different roles... imagine a restaurant with a menu. The menu
disassembles into dishes, and each dish disassembles into ingredients,
and each ingredient is either simple (e.g., salt, pepper, flour), or
it is a recipe, itself, such as béarnaise sauce or hollandaise
sauce..."

To be honest, this is non-trivial stuff and the 'recipes' example
comes up often enough in this group for me to wonder if there isn't
already a product available for such purposes. Perhaps you could
research it and post back your findings? TIA.

Jamie.

--
 
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
(e-mail address removed)
 
Back
Top