I forgot to mention that in the script trigger I used a few perform scripts near the beginning of the steps and then used perform find for the remainder of steps. This was done as a test but I still have the issue.
See FileMaker Pro 15 Help for searching on numbers. If you want to find the number 101 your search would be "==101". If you are sure of your data, you may only need to search for "101". A search for "#" will (should) find a single digit, not two digits or three digits.
1 of 1 people found this helpful
My best guess is that your drop down is not set up on a field with global storage specified. You select the store on one record, but after the find the current record is different and you then might see a different value in the field of this other record.
Not only would a global field not have this issue, you can use it to create a much simpler script for finding these records:
enter find mode [ ]
set Field [ masterfile::St101 ; masterfile::globalField ]
Set Error Capture [on]
Perform Find [ ]
will find records for any store whose number is selected in the global field.
Wow! That worked. The field was not a global field. It is now and the issue went away.
Thank you very much PH.
Thank you for the suggestion Malcolm.