1 Reply Latest reply on Feb 18, 2010 12:07 PM by philmodjunk

    Head of household

    deliciousapple

      Title

      Head of household

      Post

      I have a client database. I would like to be able to have a way to relate family members. Maybe a drop down field titled "head of household" that list all names in the client database, that allows me to choose a head of household.  Then a portal on the client form that shows the family members.

       

      I suppose this involves creating a new client table occurrence.

       

      Any ideas?  I'm stumped!

       

      Gene

       

      Mac osx 10.6.2

      FM 10

       

       

        • 1. Re: Head of household
          philmodjunk
            

          You'll need an additional table to function as a "Join Table" here. You have a many to many relationship. Many clients are "related" (in both senses of the word) to many clients.

           

          Clients--<Family>--HouseHoldHead (HouseHoldHead is a second table occurrence of clients.)

           

          Clients::ClientID = Family::ClientID

          HouseHoldHead::ClientID = Family::HHID