Does this mean I create a find in the old database.
Then open the new database and click import. It will only see the find in the old database and NOT ALL the records.
Would this work this way?
If the source file is already open, Import Records will copy over the records from the source table (occurrence)'s found set. But what you describe seems a lot of work just to separate records by zip code when you can easily work with groups of records with a common zip code without having to move them to another table.
What do you plan to do with these records once you have copied them into other tables?
Thank you, Phil!
The reason I want to do this is that I want to export data in groups into a certain Mailchimp list.
For example, six zip codes in list 1, eight zip codes in list 2, and all the remaining zip codes in list 3.
So far I only could do a find for one zip code. Can I do a find with multiple zip codes as well? This would help.
But don't you need to export the data to a text file instead of to another FileMaker database in order to use that with MailChimp?
You can definitely do a find for multiple zip codes.
Here's the manual steps:
Enter find mode and specify the first zip code
Then pull down the Requests menu and select "New Request".
Now enter the second zip code
perform the find and you'll find all records with the first or the second zipcode.
You can also find one set of records, return to find mode, specify new criteria and then use Extend found set instead of perform find to get a found set of records from the first find or the second.
These methods can also be scripted.