I have a calculation that is repeated each time the value in my Layers field changes. I've assigned the Script Trigger OnObjectExit:BdFt_Calclation, so that each time the value in Layers is changed, the Board foot (BdFt) value is re-calculated and inserted into the BdFt (field).
My problem is the value for BdFt doesn't always show in my Reports or Layout. For those records that are missing BdFt, I can got to the Layers field, TAB and the Script Trigger will update BdFt.
I have a set process for the users that input changes to the database and when I check the table, all of the required values are there but when I look at the BdFt field it's empty. I've also tried changing the Script Trigger from OnObjectExit to OnObjectModify and still have the same problem.
BdFt is the target field that's set as a result of the BdFt_Calculation script and Commit Records is the last script step.