Is kp_BOMid unique for every record in the BOM table? Or do you have more than one record in BOM with different BldQtyu values but the same kp_BOMid value?
If you have just one record in the BOM table for any given kp_BOMid, what you describe should work, provided the "context" table occurrence matches the name of the Table Occurrence specified for the BOM Line items portal where you are trying to set this up.
Each BOM has its own unique kp_BOMid (its the unique identifier). Each BOM has multiple BOM Line Items related to it though. Each BOM Line Item record has two fields I am interested in: "Qty" and "BuildTotal"; and each BOM record has a field: "BuildQty". I want the user to be able to pull up any given BOM record, adjust the "BuildQty" field to the number of widgets that we're building from that BOM, and have each BOM Line Item's "BuildTotal" field update to be the "Qty" (from the BOM Line Items table) multiplied by the "BuildQty" (from the related BOM table). I currently have "BuildTotal" as a calculation field of BOM::BuildQty*Qty, but its not working (the field just says "0").
Actually wait, nvm, its working now...forgot to save my script (duh) thanks!