M
Marco Silva
Hi.
I need to build a query, that I don't know if it's easy or difficult.
I have a production plan. I in this production plan I have the product that
i'm to produce.
Image:
ProductA
ProductB
ProductA and ProductB are composed by several other products, such as sugar,
milk, chocolat, etc...
When, to help my colleage a build a query that tells her to many quantaty of
each ingreadient she needs to produce all products, in this case Product A
and B.
This querie says how much quantaty she nedd of sugar and the name of the lot
where the sugar is.
This query insert the query result into a table. After she has as form to
insert the real quantaty of ingredients that where really put in production
to be consumed.
Sometimes. the productin plan is changed after she inserts the ingredients
quantaty in the table (from that query result). Here it comes the problem.
She had already to start filling the new table.
Imagine that she had this on the table(from that query result). , to produce
A and B
---------------------------------------------
PlanNO Ingredient QT QTReleased
6 Sugar 10
6 Salt 6
then she updates manually:
PlanNO Ingredient QT QTReleased
6 Sugar 10 15
6 Salt 6 9
For some reason, the produce plan has to change, and instead product B we
will produce C.
C product don't need Salt but needs Chocolate and also Sugar.
So would that, in records that were not need anymore to delete, the records
that were still needed to only change the field QT(it's the quantaty needed)
The final would be:
PlanNO Ingredient QT QTReleased
6 Sugar 16 15
6 Chocolate 12 16
So now here my colleague new what the changes were and what she would must do.
Is there any way to make this work?
Regards in advance,
Marco
I need to build a query, that I don't know if it's easy or difficult.
I have a production plan. I in this production plan I have the product that
i'm to produce.
Image:
ProductA
ProductB
ProductA and ProductB are composed by several other products, such as sugar,
milk, chocolat, etc...
When, to help my colleage a build a query that tells her to many quantaty of
each ingreadient she needs to produce all products, in this case Product A
and B.
This querie says how much quantaty she nedd of sugar and the name of the lot
where the sugar is.
This query insert the query result into a table. After she has as form to
insert the real quantaty of ingredients that where really put in production
to be consumed.
Sometimes. the productin plan is changed after she inserts the ingredients
quantaty in the table (from that query result). Here it comes the problem.
She had already to start filling the new table.
Imagine that she had this on the table(from that query result). , to produce
A and B
---------------------------------------------
PlanNO Ingredient QT QTReleased
6 Sugar 10
6 Salt 6
then she updates manually:
PlanNO Ingredient QT QTReleased
6 Sugar 10 15
6 Salt 6 9
For some reason, the produce plan has to change, and instead product B we
will produce C.
C product don't need Salt but needs Chocolate and also Sugar.
So would that, in records that were not need anymore to delete, the records
that were still needed to only change the field QT(it's the quantaty needed)
The final would be:
PlanNO Ingredient QT QTReleased
6 Sugar 16 15
6 Chocolate 12 16
So now here my colleague new what the changes were and what she would must do.
Is there any way to make this work?
Regards in advance,
Marco