Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

multi criteria relationships

multi criteria relationships

multi criteria relationships

I need to create a portal that can show multiple records base on relationships between 2 files. Currently I can base a relationship on 2 or more fields using the "and" operative, but I need it to be an "or" because I want to find any occurance of a related table if the "key" is in any of 2 fields of the related table.

Any suggestions?

RE: multi criteria relationships

Not much info to work with, but here we go.

The solution is to use a separate relationship for each match criteria, then have a calc in the parent table check if only one of the relationships has related records. If so, it builds the key. This is then matched with the multi-line on the child side.

parent_xor_key (calculation, text result) = case(not isempty(rel by criteria1::recordID) xor not isempty(rel by criteria2::recordID); g_criteria1 & ΒΆ & g_criteria2 )

Just as a matter of interest - can you explain why you are trying to do this in this case? I don't see what the OR relationship will do for you.

What I can see is that it will show all data related to an item, and all the other items separately (but not items on not related items). Is that what you want?

If so, I would use two portals - one which showed all related items, another which showed all remaining items.

I'm not saying OR relationships are not needed, just asking what you are trying to do here.

RE: multi criteria relationships

Thanks for your input - I want to see in a portal of a table of records that could have a match in field 1,2 or 3.

Explanation, my agents can have a seminar that they are either the lead agent, backup agent or presenter and I want to show the seminar info in a portal.

RE: multi criteria relationships

Then I would go for the 3 portals.

Lead Agent, backup agent and presenter.

This way it will be easy to have, at every given moment, an overview.

RE: multi criteria relationships

Thanks for your input.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close