Filemaker Pro 10 TU693LL/A Benutzerhandbuch

Lesson 3

  

|

  Finding and sorting records     19

Sometimes you need to find records that match more than one criterion in a single field. For example, you 
may need to find all members located in either New York or London. This type of search is commonly 
referred to as an OR search, because your found set will consist of records that match any one of the find 
criteria. 

To perform an OR search in FileMaker Pro, you will need to use multiple find requests. 

Type the first search criterion into the appropriate field of the first find request.

Create a second find request and enter the second search criterion in the same field. 

When you click the Find button, FileMaker Pro will retrieve all of the records that match any of the criteria 
you’ve entered.

To find all members living in New York or London:

1. Click Find in the status toolbar.

2. Type New York in the City field.

3. Click New Request in the status toolbar.

Notice that the status toolbar shows that there are currently two find requests.

4. Type London in the City field of this second request.

5. Click Perform Find in the status toolbar.

Your find request returns a found set of six records for six members who live in either New York or 
London.

Sometimes, you might want to find records that match a range of criteria within a single field. For example, 
you might want to find all of the records that fall within a one-month period, or locate all of the sales invoices 
numbered between 500 and 1000. 

To perform this type of search in FileMaker Pro, you use a special range symbol in your find request to 
specify the lower and upper limits of your find criteria.

To find the members who paid their membership fees between January 1, 2009 and June 30, 2009:

1. Click Find.

2. Type 1/1/2009 in the Date Paid field.

FileMaker Pro uses the date format specified in your system settings, so the date format you see 

and enter might differ from the format shown in this tutorial.

Number of find requests