Family Tree Report

[Arman Mirkazemi]

Hi all, I was wondering if anyone here has ever done a familytree report. Im
doing a small family tree application in Access. But I dont know how to do a
family tree out of these informations that I have in my Members Table:

Each member has a unique ID to identify, one Father ID, one Mother ID and
one Partner ID. Through this I have managed to get the families, but I dont
know how to go on about a family tree. Could someone show me how its done?

 

[Allen Browne]

There is an example SQL statement at:
http://members.iinet.net.au/~allenbrowne/ser-06.html

The example was prepared for animal pedigrees, and so does not handle the
more complex human relationships such as step-parents and adopted parents,
but it does give you the idea of how to relate records from the same table
to each other.

 

[Connie]

I am in agreement with Joseph. Too many variables. We
created a family tree report that uses 4 fields and
connects mom and dad and kids regardless of last name.
But that's where it stops. We didn't want to get into
the sticky wicket involved with genealogy.

Our report is quite cool though!

Connie