Genealogy Database

Question

starting a personal project to document my family. gathering the data in excel first.
in the table I want each row to represent a family member and associated ID. How do I associate another user with FirstName, LastName under one column.
ex. Father_firstname, Father lastname, UserID.
id:1
first: John
last: smith

father
id:67
first: Jon
last:smith
when the user views this data they should see first,last under heading father.

how do I structure this in a table?

Answer 1

in excel add two columns ie level and parent_id; the first indicate the level in the hierarchy (father level 1, all sons or daughters level 2 and so on), parent id instead has the id value of associated user (if father has id 65 all his sons or daughters have parent id 65). the header of hiearchy as the father has in parent id the same value of own id (in our example 65). after these operations sort all data by column parent id and then by level