I have a recipe management database that has ingredients, suppliers and recipes. Is there a way to link the recipe to the ingredients table.
Eg: I create a recipe and attach a button that makes the recipe into an ingredients but keeps the cost dynamic. I have a script that creates a new ingredient by lookup, but if the recipe cost changes it does not update. So what I am lookin for is a way to create an ingredient from a recipe but keeping them linked. Not all recipes need to become ingredients, just the ones that will be used as a base to other recipes.
So a recipe of pasta sause is made and yeilds 1ltr for a cost of $9.00, then made into an ingredient. When the recipe has changed and now costs $9.50 the ingredient also is updated.