I don't know whether this is a query or table question, so am trying it here first.
I have a stock movement/consumption database and want to add cocktail recipes to it and am struggling.
I have attached a JPEG of the product table which is where everything lives. What I want to be able to do is build recipes using the existing products as ingredients and then feed the total back into the product table in the 'cocktail sales' column.
What I should be able to do is create a recipe using a form and enter up an amount of each product used in that recipe. The trouble is I can't get the consumption to relate to the product, I think I am making fairly basic errors.
I don't know what the basic structure should be, any help would be appreciated and could well save what is left of my hair
I'm using Access 2007
I have a stock movement/consumption database and want to add cocktail recipes to it and am struggling.
I have attached a JPEG of the product table which is where everything lives. What I want to be able to do is build recipes using the existing products as ingredients and then feed the total back into the product table in the 'cocktail sales' column.
What I should be able to do is create a recipe using a form and enter up an amount of each product used in that recipe. The trouble is I can't get the consumption to relate to the product, I think I am making fairly basic errors.
I don't know what the basic structure should be, any help would be appreciated and could well save what is left of my hair
I'm using Access 2007