• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Finding and Sorting Records > Doing Multiple-Criteria Searches

Doing Multiple-Criteria Searches

While constructing multiple-criteria searches takes more time than single-criteria searches, they enable you to cast a customized, fine-mesh net for exactly what you’re seeking.

To narrow a search using multiple criteria:

1.
Choose View > Find Mode or use your keyboard: (Windows) or (Mac). Type what you’re seeking into the relevant field. Click the Find button or press or (Figure 5.9). The records matching your first criteria will appear in Browse Mode (Figure 5.10).

Figure 5.9. A multiple-criteria search begins just like a single-criteria search: Type in your search term and click the Find button or press or .


Figure 5.10. In this example, 11 records match the first search criteria: houses costing $200,000 or less.


2.
Switch back to Find Mode and type your second search criteria into another blank field (Figure 5.11).

Figure 5.11. Switch back to Find Mode and type your second criteria into any field. Do not press the Find button.


3.
Choose Requests > Constrain Found Set (Figure 5.12). FileMaker will search through the first found set and display only records that also meet your second criteria, thereby narrowing or constraining your search (Figure 5.13).

Figure 5.12. Instead of pressing the Find button, choose Requests > Constrain Found Set.


Figure 5.13. FileMaker will search through the first 11 records and narrow, or constrain, the results to the eight houses that also meet the two-bath criteria.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint