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