>>Upon thinking about this more, you shouldn't even need a Child or Sibling relationship, because this data can be derived from the Mother and Father fields. For example, to find all of my bothers and sisters, and half brotherd and sisters, I simply find all of the people who share on or both of my parents.
>>
>>To find all of my children, I only find all the records who consider me their father.
>>
>>That's down to 3 relational fields in the people table.
>
>I thought of a great test for your table: Ever heard of the song 'I Am My Own Grandpa' ? Maybe this would even be a candidate question for VFP certification:
>
>Given the people table defined thusly...(blah,blah,blah)....write a SQL-SELECT statement that derives those people who are their own grandparents.
Geesh. To write a test question, don't you have to write the answer first?
Erik Moore
Clientelligence