Did you post your code and data design?
How close is what your doing to the example I posted above?
Please export your table data or some non-private representative sample.
(After verifying my data and SQL) Here’s what I did in FMP:
Then, this layout:
–
The data I imported is this:
ID,NAME,RELATIONSHIP,RELATED_TO
1,Fred,Is Son of ,2
2,Alan,Is father of,1
3,Peter,Is a Friend of,1
4,Susan,Is a sister of,3
5,Bill,Is a Brother of,3
6,Bill,Is a Friend of ,2