SQLTeam.com | Weblogs | Forums

Generating a family tree

tsql

#1

Heya comrades,

I have an excel sheet which contains data about children and their parents, profile etc. I am interested in creating 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


#2

Family trees are complicated. Consider a full package like gramps