Triple Posted April 21, 2010 Posted April 21, 2010 Hi everyone, I had a newbie question. I am trying to figure out the best way to display a relationship between 2 records on the same table. Basically what I have is a "Parent" table and a "Child" table. I can display all of the parent's children in a portal on the parent screen, but cannot figure out how to display the siblings of the children on the "Child" layout. For instance if John has 2 sons Jake and Jason, both sons appear on John's layout in a portal. How do I get Jake and Jason to appear on each other's layout when they are in the same table? Thanks
comment Posted April 21, 2010 Posted April 21, 2010 Define a self-join relationship of the Child table as: Child::ParentID = Child 2::ParentID AND Child::ChildID ≠ Child 2::ChildID Place a portal to Child 2 on a layout of Child. Note: Child 2 is another occurrence of the Child table on the relationship graph.
Triple Posted April 21, 2010 Author Posted April 21, 2010 How would this work in the case of multiple siblings? I currently have 300-400 parents with anywhere from 1 to 6 children. Would I need to keep growing the number of tables as needed?
comment Posted April 21, 2010 Posted April 21, 2010 No - the portal shows all siblings of the currently viewed child.
Recommended Posts
This topic is 5389 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