and I always thought one egg+ one sperm = new entity
your way of thinking would distroy the whole field of forensic science :-)
Peter
>>I have to create a family tree of sorts.
>>since everyboy has ONE mother and ONE father only I created a table :
>>table 1: Person_id, Father_id, Mother_id (relatives)
>>table 2: person_id, spuse_id, startdate,enddate (spouses)
>>
>>
>>now given a certain person I need to identfy all of his/her relatives
>>
>>like:
>>
>>Peter
>> Alex, father
>> Anna, mother
>> Louis, Grandfather
>> Anita, Grandmother
>> Karl, grandfather
>> Hilde, grandmother
>> Nici, child
>> Susi, child
>> Anna, child
>> karl, child
>> Till, grandchild
>> Jana, grandchild
>> Heimo, sibling
>> Uli, Sibling
>>......
>>
>>
>>has anybody done something like this before and is willing to share
>>maybe anybody has better ideas how to accomplish this
>>
>>
>>this is similar to a bill of material, but with 2 pointers (parent, parent, child) rather 1 pointer (parent, child)
>>
>>Thanks
>>
>>
>>Peter
>
>With enough liberalism and medical freakishness in place,..
>
>Johnny may have 2 mommies
>
>Sally may have 2 daddies
>
>We had to allow for this in an application written for the state of KS.
Peter Cortiel