I have 2 files:
File A - hosted on FileMaker Server in the cloud
File B - running locally on my Mac. File B has a file reference to File A. It also has a layout "ServerCustomers" which is based on a table occurrence from File A.
All fine so far. I'm working on a script that goes to the "ServerCustomers" and performs a find, which works fine and gets a found set of 100 records out of the total of 5000 records. I then switch back to a layout based on a table occurrence in File B and use the Import Records script step to import the found set of 100 records.
Problem is that instead of getting the 100 records I'm getting the 5000 (total records in Customers table in File A) after the import, even though I've done a find to reduce the found set.
Anyone know what I'm doing wrong here?