Subforms

[fwillia]

I am trying to get my subform to do the following. Please let me know if this is possible.


Material: 12344 Color: blue QTY in FG: 50000

REQ DATE PROJECT REQUIREMENT BALANCE
1/10 1 10000 40000
1/15 2 10000 30000
1/20 3 10000 20000

Ending Inventory: 20000



I have 1 query that has all of the information you see above in it.

[ajetrumpet]

if WHAT is possible?

[fwillia]

I am trying to create a row in the subform that will decriment the requirement quantity from the inventory that is in Finished Goods.