Does anyone have any ideas on how to label relationships in this CRM we are building? We have multiple relationships we want to label such as spouses, siblings, advisors, parent-child. We also want it to work in the inverse so it shows that Sally is the child of Tom and Tom is the parent of Sally.
@gabsbabs300 , I believe you'd want to not just make them reflexive, but also to allow multiple relationships. (After all, Sally may be the parent of Joe, Joe is the sibling of Jack, and Jack is the child of Sally.) In order to do this, you'd need a People table and a Relationships table. And then a Connections table that brings them all together.
