Generating a family tree

[absolom1985]

Heya comrades,
I have an excel sheet which contains data about children and their parents, profile etc. I am interested increating a family tree whereby every child is linked to their parent/Household (father/mother/guardian) which are captured in separate columns within the same sheet. I imported the file into MS Access and have tried to query it in different ways but i have not succeeded in getting that missing query. It's quite a big list (over 2000 records) and i cannot not do it manually.
Any support will be highly appreciated.


Absolom

[June7]

IMO, family tree type of db is one of the most difficult to design. Because, eventually, children become parents and grandparents. How much history are you maintaining?

What do you mean by 'missing query'? Exactly what do you want query to tell you?

[Micron]

This might give you an idea of what you're up against:
http://allenbrowne.com/ser-06.html