I have a very simple find script that works fine on FMP but in Go it returns a foundcount of 0 records.
I've been troubleshooting this for a couple of days and the only thing I can come up with is that my primary key field is a number field and the foreign key is a text field. Could that be the issue?
I think so it’s the issue. Both the primary and foreign key should be of same type. I guess that it shouldn’t work on Pro.
It would be interesting to know FMP and FM GO versions, and if file is open from FMS then the server version.