This old man needs help please, pulling my hair out. My two interests in life are Access and Genealogy. I have now built my own Access Genealogy Database. It is not complete yet, I am continually updating and improving my database.
My challenge now is to build a relationship table between individuals and the home person, the home person is static, set by the database administrator. So, each person’s form will be different in respect of the home person.
For each person there is a relationship input, for example, 1st Cousin, Granddad, Father, Home Person etc etc.
I want to generate a report for each person that shows that persons relationship to the home person, this report will be different for each person. I would like the report to be in the form of a list,
For example,James Mitchell III 1769 – 1848
3rd Great Grandfather
V
William James Mitchell 1803 – 1873
Son of James Mitchell III
V
Adolphus Sharp Mitchell 1850 – 1929
Son of William James Mitchell
V
Charles Mitchell I 1894 – 1967
Son of Adolphus Sharp Mitchell
V
Billy Mitchell I 1925 – 2015
Son of Charles Mitchell I
V
Anthony Paul Mitchell I 1947 –
You are the Son of Billy Mitchell
To be honest with you I do not know where to start, I started building a Query but could not complete because I just did not know how to proceed. Any help would be appreciated, thank you in advance.