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.
