Help

Food costing calculator tutorial

Topic Labels: Base design
1654 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Judy_Hackett
4 - Data Explorer
4 - Data Explorer

Hi I have been trying to update my recipes into the food costing calculator. so far have done the ingredients list - but i have hit a problem.
when i enter more than one recipe that has the same ingredient - eg an onion - it changes the ingredient amount in the ingredients list. that would be fine if i only used onion in one recipe - but it is in many recipes at different quantities.
maybe i have not set the ingredients list up correctly? or may be i need to be able to have the recipe card multiply a single unit of the ingredient eg 1 gram or ml so that it works?
any hints how to use this food calculator would be greatly appreciated.
Judy

2 Replies 2
Wladimir_Feldma
4 - Data Explorer
4 - Data Explorer

If you have “many-to-many” relationship it’s a rule of thumb that you need additional table to manage that relation. In this case it will be a “ingredients for Recipes” table where you’ll have a Recipe column, Ingredient column and Amount column. For more details (and ongoing discussion) you can look at the question below: Recipe cost calculation

Judy_Hackett
4 - Data Explorer
4 - Data Explorer

thank you i will work on that angle thanks! finger crossed