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

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

Similar Threads

Drink receipe query 0
Creating a meal planning calendar/weekly grocery list 9
List all tables, including document structure 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Copying records from one (sub)form to another subform using Append 1
help needed with writing a bit of code 2
Table Layout 3
count of dishes that contain specific ingredients 1

Top