Hi Folks, can someone help me with this? I have three tables,
1) Work done List
In this table, each item has ID, Code and 3 phases for each item. user will select which phase is completed through a form.
Ex.
001 | D1 | Phase 01 | Phase 02 | Phase 03
002 | FW1 | Phase 01 | Phase 02 | Phase 03
2) Material List
In this table, each item has material quantities
Ex.
001 | D1 | Material 1 | Qty
001 | D1 | Material 2 | Qty
002 | FW1 | Material 1 | Qty
002| FW1 | Material 2 | Qty
002| FW1 | Material 3 | Qty
3) Material takeoff
D1 | [Calculate Qty]
I want to calculate material quantities based on Phases in the work done list table
LinkedIn
Twitter
