I've formatted my query as such:
However, I get a 102 error (field missing).
The global field is IN myLayout.
If I remove the query for the global and do the find, I can see in the fmresultset.xml results that the field definition exists, but, as expected, there is no value.
Any ideas about what I'm doing wrong or how I can troubleshoot this? How do I use this global field syntax so that it recognizes it?
Using FMP12 Adv./FMServer 12