AnsweredAssumed Answered

Batch information

Question asked by EricBrown on Aug 12, 2013
Latest reply on Aug 12, 2013 by philmodjunk

Title

Batch information

Post

     This is the scenario, I have a table batches linked to recipes linked to recipe data linked to ingredients:

     Batch >-- Recipe --< Recipe Data >--- Ingredients  

     A batch makes multiple quantities of a recipe, so the qty of ingredient in the Recipe data has to be multiplied for the batch and relates to that batch.  Right now that calc is done as Recipe Data::BatchQty = Batch::Multiplier * Recipe Data::IngredientQty.

     That is the wrong way to do it because the BatchQty changes with every new batch and reflects back to other batches.  Suggestions? 

Outcomes