G
Graeme at Raptup
Hi,
I have tried a number of variations to this theme but still no joy!
With the help of Allen Browne I now understand how to use a bill of
materials (assembly) type set-up, however I'm not convinced that it solves my
problem.
In the bakery we have ingredients (e.g. eggs, sugar) that are combined to
form a mix (e.g. pudding base, sauce, icing) and a number of mixes are used
to form a recipe (e.g. Toffee pudding). That's the easy part.
Each time a mix is made it is called a batch and each batch has details
through the manufacture process such as mixing, ovening, depanning etc.
Most (raw) ingredients are inspected upon delivery at the bakery.
Assuming that I am starting again from scratch I have identified the
following relationships;
1 Recipe = Many Mix
Many Mix = Many Ingredients
1 Ingredient = Many RMInspection (Raw materials)
1 Mix = Many Batches
1 Batch = Many BatchEvalution
1 Recipe = Many RecipeEvaluation
I find that the tricky part is mimicking the following form/subform that
exists in paper form at the bakery;
Mix (Main Form)
Batch (Subform)
Ingredients (2nd subform) that includes IngredientID, Quantity,
RMInspectionID and a field Checked (Y/N)
The forms for Mix & Batch could be one & the same I guess. (Note that
ingredients measured for each mix are all in kg's)
I had made some progress with a bom set-up that looked like this;
Product (ProductID, ProdName,Recipe, Mix, Method)
ProductInProduct (TargetProductID, SourceProductID, Quantity)
Batch (BatchID, ProductID, CreateDate, UseByDate, LoadedBy)
RMInspection (RMCodeID, ProductID, LotNumber, Supplier)
In the relationships window the Product table was copied to form Product1,
both are linked to the ProductInProduct table.
Creating recipes & mix I create a query looking up those fields that are
called Recipe & Mix in Product table and then included 'ingredients. Fine.
But then trying to create a form as mentioned earlier - problem.
Help!
Thanks,
Graeme
I have tried a number of variations to this theme but still no joy!
With the help of Allen Browne I now understand how to use a bill of
materials (assembly) type set-up, however I'm not convinced that it solves my
problem.
In the bakery we have ingredients (e.g. eggs, sugar) that are combined to
form a mix (e.g. pudding base, sauce, icing) and a number of mixes are used
to form a recipe (e.g. Toffee pudding). That's the easy part.
Each time a mix is made it is called a batch and each batch has details
through the manufacture process such as mixing, ovening, depanning etc.
Most (raw) ingredients are inspected upon delivery at the bakery.
Assuming that I am starting again from scratch I have identified the
following relationships;
1 Recipe = Many Mix
Many Mix = Many Ingredients
1 Ingredient = Many RMInspection (Raw materials)
1 Mix = Many Batches
1 Batch = Many BatchEvalution
1 Recipe = Many RecipeEvaluation
I find that the tricky part is mimicking the following form/subform that
exists in paper form at the bakery;
Mix (Main Form)
Batch (Subform)
Ingredients (2nd subform) that includes IngredientID, Quantity,
RMInspectionID and a field Checked (Y/N)
The forms for Mix & Batch could be one & the same I guess. (Note that
ingredients measured for each mix are all in kg's)
I had made some progress with a bom set-up that looked like this;
Product (ProductID, ProdName,Recipe, Mix, Method)
ProductInProduct (TargetProductID, SourceProductID, Quantity)
Batch (BatchID, ProductID, CreateDate, UseByDate, LoadedBy)
RMInspection (RMCodeID, ProductID, LotNumber, Supplier)
In the relationships window the Product table was copied to form Product1,
both are linked to the ProductInProduct table.
Creating recipes & mix I create a query looking up those fields that are
called Recipe & Mix in Product table and then included 'ingredients. Fine.
But then trying to create a form as mentioned earlier - problem.
Help!
Thanks,
Graeme