Title
Perform Find
Post
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?
Thanks.
From
http://sixfriedrice.com/wp/the-secret-life-of-find-mode-requests/
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 anAndsearch because records have to match the first field and the second.Multiple Find Requests
http://help.filemaker.com/app/answers/detail/a_id/5210/~/multiple-find-requests