When FileMaker actually processes your find requests, it finds records that match any one of them. Consider these examples:
If you put “Bill” in the first name field, and “California” in the state field in the same request, FileMaker will only find customers named Bill who live in California.
On the other hand, if you create two requests (one with “Bill” and the other with “California”) you’ll probably get more records. FileMaker finds everyone named Bill (no matter what state he lives in). It also finds everyone from California, no matter the name.
In nerdier terms, multiple requests create an
Orsearch: Records match either the first request or the second. Multiple criteria in one request makes an
Andsearch because records have to match the first field and the second.
Multiple Find Requests