Ok I adjusted script to deal with both cases, but what's up with FM??
I suspect what you are seeing depends on the sorted state of the found set at the time you create a record—
• If the found set is unsorted, a new record will appear as the last record
• If the found set is sorted, the new record will appear in its sorted order
Thanks for that suggestion, but the found set is not sorted in either scenario. Essentially it is the same script behaving in two different ways. In one situation the file is served, in the other run from local machine.
When the file is hosted, do 2 or more FMP clients execute the script simultaneously? Or does this occur with only one client connected?