1 Reply Latest reply on Dec 19, 2010 11:09 AM by davidanders

    Perform Find



      Perform Find


      I am running a script that utilizes Perform Find function. The script puts a stored variable in multiple fields. The problem I have run into is the Peform Find function automatically assumes you want the script to use "and". I am looking for an "or" statement. 

      In my transaction table it pulls foreign id's from the customer database which means there could be up to four customers assigned to a transaction (seller 1, seller 2, buyer 1, buyer 2). Part of the purpose of the search is to see if the customer is associated with the transaction regardless of whether or not it's a seller or buyer.

      Is there a work around for this or a better function to perform this?


        • 1. Re: Perform Find



          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 Or search: Records match either the first request or the second. Multiple criteria in one request makes an And search because records have to match the first field and the second.

          Multiple Find Requests