"OR" relations

[zinneken]

Multi Criteria are always styled as "AND" in relations. How could I have multiple criteria styled as "OR"?

This is my issue. 2 tables, A & B. Table A has field 1A, table B has field 1B, 2B, 3B. The relation between the tables should be:

1A = 1B

OR

1A = 2B

The contents of 3B shows up in a portal for all records that match 1A=1B OR 1A=2B.

Can this be done in FM and if so how? Thanks!

[LaRetta]

You would concatenate table B's fields as:

1B & ¶ & 2B & ¶ & 3B

... turning it into a multiline. Then 1A will relate to 1B or 2B or 3B but ... I question why you have three fields in table B which might relate. Usually when you have multiple 'like' fields, it suggests that another table might work better, holding multiple records. Anyway, using the concatenated field in table 2, the relationship would be:

Table A::1A = Table B::newConcatenatedCalc

If you are sure you will NEVER have more than three fields then you are safe but things like this can tend to grow and you might kick yourself for not structuring it using another table to begin with.

LaRetta :wink2:

[zinneken]

Great! Exactly what I needed. Thanks so much. :worship: