Refreshing a calculation field with SQL
I have a calculation field that uses ExecuteSQL to determine its value. The SQL finds a specific field and the calculation field is the result. I've tested the SQL in data viewer and it works. Also, when I set or change the calculation and save the change, it reflects the correct value. However, when I change the referenced field from 1 to "" or back, the change does not show. The calculation is unstored and the result is a number.
Would an auto-enter work better? Is there another solution? Worst case, I can script the checkbox to manually change the field and any other fields, but I'd rather not.