Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 5389 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

Posted

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?

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.