Access 2019 I hope this is posted in the correct forum. Maybe it should be in the programing forum????
I have a database which list about 6 generations of my family members. In the main form (frmMain) there are 3 fields of interest for this posting. They are family member (FName a key field), generation number (GenNumber), and the family member parent’s name (PName).
I have been able use a query to generate a report which list each parent and their children. This report runs very well with no problem.
I now want to generate a report which list the generation number of each parent and their children. I am able to show in this report the generation number of the child, but I am unable after many different attempts, to show the generation number of the parent (Which is on a different record from the child's record). In the report I could simply subtract 1 from the child’s generation number but this would defeat the purpose of verifying the integrity of the database. In addition, ideally, I would like to have the generation number entered automatically when a new child is entered into the database by adding 1 to the parents’ generation.
I have attempted to use dlookup to populate a hidden field for the parents’ generation number in the child’s record. I have been unsuccessful with this approach.
Any help would be greatly appreciated.