Calculations Without Calculated Field Question
I currently have some fields set up as calculated fields in my database that I display on my layout. I want to remove them because of issues I am having when I move my database to my IPAD.
Is there a way to calculate a value from a script file without using a calculated field.
For example, I have flda which is defind as a number and fldb which is also defined as a number.
On my layout I wnat to display the result of flda + fldb but I do not want to define a calulated field in my database.
Write a script that sets the Total field by calculating flda + fldb.
Make a script called Find Total
Set Field [YourTable::Total ; YourTable::flda + YourTable::fldb]
Attach this script to the OnRecordCommit script trigger in the layout options.