After having been trying all night I dare to ask these questions.
While having worked with access as a user before, this is the first time I am trying to set up a database - aiming at a family tree.
In the end: (How) is it possible to create a presentation with tree-structure?
For the database, Google gave me loads of different models. Some put all their data into one table, like the concrete names of the familymembers (sheet view), others seem to do that by forms. How does it need to be done?
Besides, I have found a model suggesting to build a chain of self-relations, duplicating the table 20 times e.g. and relate the fathers and mothers ID with the personal (primary key) ID of one copy each; the fathers and mothers ID with each a personal ID of another copy and so on.
I was wondering if doing that once isnīt enough?
Or to have an extra fathers and mothers table?
I think the gold standard were self-completing fields for e.g. fathers data (birthdate, eye- and haircolor and so on, so that the data is recorded only once - and most importantly: fatherīs father, fatherīs mother, fatherīs fatherīs father.... and so on).
Is there any chance to do that?
I have found http://www.databaseanswers.org/data_...logy/index.htm
but couldnīt find out what the relations mean, what they are for in detail and how this looks as a form or maybe as a tree?