Jump to content

"OR" relations


zinneken

This topic is 6080 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

This topic is 6080 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.