AnsweredAssumed Answered

How to perform multiple search request in Filemaker 10

Question asked by mkroeker on Mar 12, 2010
Latest reply on Mar 12, 2010 by WoodApple

Title

How to perform multiple search request in Filemaker 10

Post

Hi there,

 

I'm using Filemaker 10, on Mac OSX 10.6.2.

 

I'm trying to find the fastest way to perform the following search ...

 

I have a database of 699,000 records, from across Canada and I would like to perform a search for the following cities in the CITY field.

 

 

Acadia Valley Acme Alix Alliance Altario

Amisk Bashaw Bawlf Big Valley Birchcliff Bittern Lake Blackfalds Bodo Botha Bruce Byemoor Cadogan Camrose Carbon Castor Cereal Champion Chauvin Chinook Clive Compeer Consort Coronation Craigmyle Czar Daysland Delburne Delia Denwood Donalda Drumheller Duchess East Coulee Edberg Edgerton Elnora Empress Endiang Erskine Esther Ferintosh Forestburg Gadsby Galahad

Gem Gwynne Halfmoon Bay Halkirk Hanna Hardisty Hay Lakes Hayter Heisler Hobbema Holden Hughenden Hussar Huxley Irma Irricana Jarvis Bay Kathyrn Kelsey Keoma Killam Kingman Kinsella Kirriemuir Lacombe Lougheed Meeting Creek Metiskow Mirror Monitor Morrin Munson Nevis New Brigden New Norway Norglenwold Ohaton Oyen Paradise Valley Patricia Pine Lake Pollockville Ponoka Provost Ralston Red Deer Red Deer County Red Willow Rimbey

Rivercourse Rockyford Rolly View Rosalind Rosebud Rosedale Station Rosedale Valley Round Hill Rowley

Rumsey Ryley Sedalia Sedgewick Sibbald Spring Lake Springbrook St Brides Standard Stettler Strome Sunnynook Swalwell

T ees Three Hills Tofield Torrington Trochu Veteran Viking Wainwright Wetaskiwin Wimborne Youngstown

 

 

 

Is there a better way then having to create a new find request for each city?

 

 

Thanks for the help  :)

Outcomes