I have an odd problem I haven't seen before and was hoping someone could help me out.
I just created a new database. Big but fairly simple.
About a dozen fields, with one auto-enter serial number field labeled "ID".
One table, no relationships. About 12.3 MM records.
I need to peel off the first million records and export them as a CSV file.
So I did a find in the ID field of ≤1000000. That should have given me a found set of the first million records.
But it didn't. Instead I got 7 records: 1, 10, 100, 1000, 10000, 100000, 1000000.
I see what's happening, but I don't understand why.
Why am I getting powers of ten instead of the first million records?
**Filemaker Pro 10; Mac OS X 10.6.3; iMac 27" Quad I7; 8 GB RAM**