AnsweredAssumed Answered

Family Contacts - show siblings, children, grandchildren

Question asked by davidanders on Dec 5, 2012
Latest reply on Dec 7, 2012 by davidanders

Title

Family Contacts - show siblings, children, grandchildren

Post

     Database will be a RunTime
     Win XP & OSX 10.5    FMPA 11

     Contact >--< Family
     Contact >--< CalEvents >--< SeedCodeCalendar

     ContactTable::ParentFamilyCode (FatherLastName - MotherLastName) [Smith-Jones]eg.
     ContactTO Portal shows Siblings, Father, Mother

     ContactTable::FamilyCode (HusbandLastName - WifeLastName) [Black-Smith]eg.
     ContactTO Portal shows Children, Husband, Wife

     Show Grandchildren?     Calculation  ParentFamilyCode & "-" & FamilyCode  ???

     Three Generations to be viewed - ParentFamily, Family, ChidrenFamily(s)

     Hierachial Solution?  Join Table?  Confusing Number Fields?

     Thank You for your time.

Outcomes