Barbara,

There are a number of things you can do to do a search with multiple 
criteria.

One method is to use multiple records for the search. This can be 
scripted or manual entry. Enter find mode, set the search field to the 
first value you are looking for. Then use the new record command and set 
the same field to the second value. You can create as many records as 
you need, when done then use the command perform find. You result should 
be everything that meets your criteria.

You can also use operators to modify how the value is used.

The search should find the key records, if you have related record in 
another table, after the find you can script a Go to related record 
scripts step and have it match all records in current found step.

Hope this is helpful
Bruce Herbach


On 10/4/10 12:47 AM, Barbara Passman wrote:
> Is there a way set relational criteria as "And/OR"?
>   I have to try to find related records when the records may be related by one or another criterion.
> When I relate records is there a way to designate that  a relationship exists if ANY one of several criterion match?
> It seems to me that  when choose several criteria FMP expects that the records must meet all the criteria in order to be related.
> Thus I cannot get accurate data reports.
>
> This limitation surprises me so I have to think that there is something I do not know how to do.
>
>
> Thank you
>
> Barbara Passman