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?

 

[Joseph Meehan]

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?

You will need to create one or more "relations" table(s). Relate the
child parent relationship. You will likely also want one for mariages and
maybe additional ones for other unusual relationships that seem to crop up,
like step parents. Then you use queries to put it all together.

You may want to consider one of the inexpensive commercial programs
available for this use. They have years of experience of development and
beta testing to get it right and to cover all the strange events they must
cover. They have features you are not likely to think of.

 

[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