Linking Related Line Items field with Table field in calculation
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)?