• JayInSA
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

Sorry....probably a pretty basic question for most of you out there, but I am still learning.

 

I am setting up a small database for enrollment at my school.  I have setup the parents names as the "Account" and the children as the "Contacts" that are then tied to that account.

 

It would be helpful to me if I could identify siblings directly on the Contacts page.  In other words, I would like to establish a lookup field on the Contact layout page so that I could easily that John Doe has 1 sister and 1 brother.  However, when I try to do this it setup in a parent-child relationship.

 

I would like to be able to do the lookup, select the sibling record and then have it automatically update the siblings record as well.  So it wouldn't be a parent-child relationship but rather a daughter-daughter relationship.

 

Any ideas?

 

Hope this makes sense.