Mime-Version: |
1.0 (Apple Message framework v1081) |
Content-Type: |
text/plain; charset=utf-8 |
Date: |
Mon, 4 Oct 2010 00:27:45 -0500 |
Reply-To: |
|
Subject: |
|
From: |
|
In-Reply-To: |
|
Content-Transfer-Encoding: |
quoted-printable |
Sender: |
|
Parts/Attachments: |
|
|
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.
|
|
|