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

    Head of household



      Head of household


      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!




      Mac osx 10.6.2

      FM 10



        • 1. Re: Head of household

          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