bizpal Posted June 17, 2004 Share Posted June 17, 2004 Is it possible to create a self-join relationship within the same file to display all the records of that file in a portal? I want the portal because I want to use navigation buttons on the left side of the screen and you can't do that in list view. I've tried to create the self-join, by matching one field with the same field in a second occurance of the table: Projects to Projects 2. Not sure where I'm going wrong. I got it to work once, which is puzzling. Gordon Link to comment Share on other sites More sharing options...
-Queue- Posted June 17, 2004 Share Posted June 17, 2004 Use an X as the operator when creating your relationship. This creates a Cartesian join, where all records are related to all others in both tables. Link to comment Share on other sites More sharing options...
bizpal Posted June 17, 2004 Author Share Posted June 17, 2004 Thanks, worked like a charm. Gordon Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7114 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