tell application "FileMaker Pro"
show (first record of database "Clients" whose cell "Client number" is "12345")
end tell
...will work some times and not others, even when the cell exists on the current layout.
Adding to the frustration is that it might work on one run and fail on the very next run, and even when it does work it may take up to a minute to do the find that was instantaneous in previous versions of FileMaker.
I've tried: show (first record of table "Clients" of database "Clients" whose cell "Client number" is "12345")
I've tried: show (first record of database "Clients" whose cell "Client number" of layout "Blah" is "12345")
I'm just not getting it, and any (job-saving!) guidance would be greatly appreciated.
Thanks,
Bill