OR Relationship

[CCBtx]

Is there a way to develop an OR relationship?

I have three fields in one database

ProjectOwner

ProjectRequestor

ProjectDelegate

I have one field in the other database

user

I want to display the record in a portal if user = ProjectOwner OR ProjectRequestor OR ProjectDelegate

Ideas?

Edited February 26, 2007 by Guest

[The Shadow]

You can make a fake field that is a list of the alternate fields, then join to that.

AnyUser = List( ProjectOwner; ProjectRequestor; ProjectDelegate )

then join the user field to AnyUser.

[Fenton]

Without getting into reasoning behind why there are 3 fields, and assuming one or more of them is the "user" in question, an "or" relationship can be implemented by putting the IDs (or names, or whatever) in a text field separated by returns. Because a relationship matches when ANY of the return-separated IDs match; in either direction, if both fields can be indexed, or from the non-indexed to the indexed one if not.

A calculation field:

ProjectOwner & ¶ &

ProjectRequestor & ¶ &

ProjectDelegate

[CCBtx]

Excellent Fenton. Thank you very much.