iNovice Posted September 21, 2006 Share Posted September 21, 2006 I'm not sure this is the right terminology for what I'm trying to accomplish, but is a self join basically replicating a table occurance alowing me to relate to the same data in a different manner? Anyway, I guess I'm trying to accomplish what I think would be a many to many relationship within the same table, or in other words I want to see an individual record in form view as I select it from a portal containing all the records within the same table and on the same layout. Or is this doable? Link to comment Share on other sites More sharing options...
iNovice Posted September 21, 2006 Author Share Posted September 21, 2006 Just noticed my post title is a typo. It is supposed to be self join portal. Link to comment Share on other sites More sharing options...
LaRetta Posted September 21, 2006 Share Posted September 21, 2006 You have the idea. Example: You have a Customer table being viewed in Form layout. On it, you place a portal of ALL customers (self-join called All Customers) which you have based upon cartesian join (X) so all customers relate. Attach a button to the All Customers portal row with: Go To Related Record [ get related record from All Customers; using current layout ] ... and do NOT check any of the result options, you will jump (when clicking a row) directly to that customer's record (using the current main form layout to view it). If you wish to end up with a set (the same set that is in the portal) then specify results as: Show Only Related Records and Match All Records in Set. Link to comment Share on other sites More sharing options...
iNovice Posted September 21, 2006 Author Share Posted September 21, 2006 I guess I didn't understand the cartesian join concept, but after selecting that and changing it from the equijoin, all the records now show up in the portal. Thankyou. Link to comment Share on other sites More sharing options...
iNovice Posted September 21, 2006 Author Share Posted September 21, 2006 Tell me it ain't so. Is it true that portals are not web compatible? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6561 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