On 2010 Oct 3, at 23:47, 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


I don't know if this is exactly what you're after, Barbara, but a relationship of A = B will get a match if A is "red⁋white⁋ blue" and B is ANY of "red", "white", or "blue". In this scenario, A is generally a calculation field that concatenates other fields, separated by a paragraph marker.