Heya Andy.
I would have at least a people table - with a few extra columns -
family head specifier - 0 if head of family, 1 if not
family id - contains 0 if a head of family
- contains the primary key of the family head record .
If you don't want to add columns in a table, then you could
make a lookup table of key values - then anyone who was referenced
as a head of family would have a record pointing back to themselves,
and a family member would have a record pointing back to the head of family.
regards [Bill]
--
William Sanders / efGroup {rmv the DOT BOB to reply}
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool DSL -> http://www.efgroup.net/shopfordsl.html
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
Failing dotNet Project? -> http://www.dotnetconversions.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
