zinneken Posted October 28, 2007 Share Posted October 28, 2007 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 More sharing options...
LaRetta Posted October 28, 2007 Share Posted October 28, 2007 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 More sharing options...
zinneken Posted October 28, 2007 Author Share Posted October 28, 2007 Great! Exactly what I needed. Thanks so much. :worship: Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6159 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 accountSign in
Already have an account? Sign in here.
Sign In Now