Hi, I am new to filemaker. There are 2000008 records in the my file. I would like to export them for each 500000.(total 2000000 needed)
How could I do it effectively? I think it is better to import them to temporary table first and then export the data.
The reason is if I omit multiple records and then show omit records only. The found set includes the 8 records that I don't want.
My approach is omitting first 500000 records then showing omit only then export data.
For second 500000 records, I will omit 1000000 records, then show omit only, then omit 500000 records, finally export data.
my client is using filemaker 16.