Searching Entire Database

[Travis]

I have a contact database with multiple tables. Is it possible to search the entire database and find all of the contacts in the same city (for a mailing list)? I can't search more than one table at a time. Can I search multiple tables?

Thanks

[Reed]

Why do you have cities for contacts spread out across more than table? Usually it's a good idea to keep similar information grouped together. Searching multiple tables would be possible with a script. Input your search criteria into global fields or a custom dialog, then create find requests in each table. Of course when you get the results from different tables, you'll have to display each found set in a separate window.

Dana