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.