Type of Family Tree

[Guest]

an I want to create a table within access database to store individual family
members general details. Within each row would include the mother and father
of the person.
I then would like to create a form in the shape of a family tree (possibly 4
generations) where, when a persons name is entered, the parents automatically
populate along the tree.
Is there a template for this or can you describe how this population of
family members would come about

Thanks

 

[Allen Browne]

If you are dealing with biological parents only, you could use this
approach:
Self Joins: tables that look themselves up (Pedigrees example)
at:
http://allenbrowne.com/ser-06.html

If you are handling half-siblings, step parents, and a range of other things
that happen in human relationships, things get much more confusing.

 

[Guest]

Brilliant - the info is exactly what I wanted. Many thanks. Ron