Return to FileMaker.com
Script critique needed
Script novice here.
The script I wrote in the image works for what I wanted it to do but it seemed very slow (for my usually fast machine). I only have 1800 records and it seems to take 5-7 seconds to execute this script.
Looping records can be slow. I don't see a need for a loop. You really didn't give enough details about your database for me to give you the best answer.
The process that set the Amt_trans field could also set the Amt_join_db at the same time or you could make the Amt_Join_Db field a calculation field.
If these fields are related then why copy the data to another field?
Retrieving data ...