Special Relationship Problem

[dhogan444]

I'm going to simplify my problem here to explain what I'm trying to do.



two tables:

tblPeople - Fields are PeopleID, PeopleName
tblRelationships - Fields are Parents, Children - both fields are for the IDs of the people. People can have zero, one or multiple children and zero, one or multiple parents.

Is there a way to show an entire lineage of names in one view? I was thinking using subforms some how? Looking for ideas on how I would accomplish this. Doesn't necessarily have to be graphically (cross tab datasheet?).

Thoughts?

[orange]

You may find some information by searching gedcom
You are really asking about hierarchies.
There is some info here http://www.databaseanswers.org/data_...logy/index.htm