AnsweredAssumed Answered

Linking Related Line Items field with Table field in calculation

Question asked by DanielClark on Nov 1, 2011
Latest reply on Nov 1, 2011 by DanielClark

Title

Linking Related Line Items field with Table field in calculation

Post

I have a BOM (Bill of materials) table with a related BOM Line Items table (which are line items of the BOM pulling parts from my Parts Inventory table). The BOM table has BOMs primary key field (kp_BOMid) linked to the BOM Line Items secondary key field (kf_BOMid). I am trying to add a field called "BuildTotal" to my BOM Line Items table that will pull from a field "BuildQty" in my BOM table and multiply it by my "Qty" field in my BOM Line Items table. I setup a calculation field in BOM Line Items to multiply BOM::BldQty*Qty (from my line items table) - however, it does not work. How can I get it to update this field with that product (and to update every time somebody enters in a new build qty for that BOM)?

Outcomes