AnsweredAssumed Answered

Complex Relationship

Question asked by dasloane on Sep 4, 2012
Latest reply on Sep 6, 2012 by schamblee


Complex Relationship


I have a table named Contacts; no problem.  Each contact (record) in Contacts can have a one-to-many relationships with other contacts within that table.  For example, Don can be Nicole's father and Don can also be Steve's brother.  I need to show all of the relationships Don has is a portal on a tab named relationships. 

Portal rows for Don might be

Name        Relationship

Nicole        Daughter

Steve        Brother

Josephine  Wife

I'm having trouble figuring out how to create the relationship map and what scriping i need to create the relationships Frown