Recipe Tables with Master Ingredient List

[rothian717]

Hello everybody,

I have recently acquired an Assistant Management position in a small restaurant and I have been given the task of creating a database of all of our Recipes with a master list of ingredients. I can easily set this up in Xcel but it is very messy and time consuming to say the least.

I would love to be able to create a master list of ingredients (1-X) With their unit of measurement (Pound, Gallon, Etc) as well as their unit price (pound of bacon= 5.00)

Now the recipes would be set up with the (ingredient-amount of ingredient-cost of amount of ingredient)

Ideally I would like to start a new recipe by opening a table, typing in a number that corresponds with an ingredient on the master table and those fields be filled in other than the amount of ingredient. Also by changing the price of an ingredient would automatically update on the recipes.

my boss wants to know how much each recipe cost as well as keep them updated when the price of ingredients change.



I'm sure there is a very simple way to do this but from trial and error as well as searching i have not been able to figure it out. just figured out the long slow way in Xcel.

[June7]

Google: Access recipe database
Review http://www.ehow.com/how_5458551_make...ft-access.html

[rothian717]

Google: Access recipe database
Review http://www.ehow.com/how_5458551_make...ft-access.html

I have had tried this and it is only part of the equation i need. I do appreciate the help.

All of the tables (recipes) need to be linked so that pricing can be updated via the master list which automatically changes the recipe costs accordingly.

I feel this project will take me a good bit of after hours work.

[June7]

I didn't look at the db template but presume it has a table of Ingredients. Possibly just need to add a field for Cost. Then create/modify queries, forms, reports to accommodate this new field.

Yes, I expect will be quite an effort but at least the template gives you something to model from if you decide to build from scratch.

[rothian717]

I didn't look at the db template but presume it has a table of Ingredients. Possibly just need to add a field for Cost. Then create/modify queries, forms, reports to accommodate this new field.

Yes, I expect will be quite an effort but at least the template gives you something to model from if you decide to build from scratch.

Its at least something i can show i found and can keep my bosses updated on progress.