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
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