2 Replies Latest reply on Apr 18, 2018 9:04 AM by SAMUEL SPOERLE

    Relationship of a Relationship Connection (Degrees of Separation)

    SAMUEL SPOERLE

      I am trying to understand how to format my data so that I group people based on their connections. I've attached some sample data to illustrate what I mean.

       

      For example, Bob Smith has 3 relationships: Jane Smith (wife), Sam Smith (Son), and Grant Hugh (friend). Sam Smith also has three relationships: Bob Smith (Dad), Jane Smith (mom), and Zach Cody (Friend).

       

      I want to be able to group Grant Hugh (Bob's) friend to Zach Cody (Sam's friend) and include everyone else in between. They are a separate group from the Matthews family.

       

      I hope I was able to explain that well. Thanks!