CCBtx Posted February 26, 2007 Share Posted February 26, 2007 (edited) 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 Link to comment Share on other sites More sharing options...
The Shadow Posted February 26, 2007 Share Posted February 26, 2007 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. Link to comment Share on other sites More sharing options...
Fenton Posted February 26, 2007 Share Posted February 26, 2007 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 Link to comment Share on other sites More sharing options...
CCBtx Posted February 26, 2007 Author Share Posted February 26, 2007 Excellent Fenton. Thank you very much. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6241 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