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

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.

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?

No - the portal shows all siblings of the currently viewed child.

Worked perfectly!

Thank you...