How?

[Guest]

I am not going to store the result of the calculation what I need is just a
"display" for the user's reference.

Just as the Nortwind's Order Form, the ExtendedPrice is displayed once the
UnitPrice, Quantity and Discount is inputted.

On the other hand I want my Form to display the SumOfDeliveredGoods for a
particular WorkOrder once another set or quantiy is inputted for delivery.
Noting that the delivery still belongs to thesame WorkOrder.

E.g., a Product is being produced and assigned with WorkOder and WorkOrder
Quntity say 1000 units. These units will be delivered staggered say 200 on
the first day and 200 on the second day and so on until the 1000 units is
met. That is why I need a display of reference so that the user will be aware
of the units that were already disposed and that the present delivery will
not exceed the required WorkOrder quantity.

This routine will continue for a particular Product and only the WorkOrder
is change and its required work order quantity.

 

[Larry Daugherty]

Assumptions:
As a work order is opened for a particular product, the quantities
of each item required to fulfill the work order is entered as part of
that work order.

Product of a particular type and quantity is logged as delivered
against a particular work order - for each such delivery. in a table,
tblDeliveries

A totals query on work order status will return items and sums of
quantities dellivered against this/each work order.

HTH