ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 302
- Office Version
- 2016
- Platform
- Windows
I have a large database for a Genealogy Project.
User will choose a family.
From my Database each family has a unique number.
Based on The family chosen. I have created a range of all the names in the family using the inique family number, to update a death.
Because that person may have been part of other families through marriages each person has a unique ID.
Is there a way to get that ID which is located one col back from the name so I can update all the Deaths. The reason I need it is because the father and son may have the same name. Here is a picture of what I looking for. If Joe Jr Dies my Drop Down allow me to choose between Joe and Jean. I would like to know Joe jrs unique code (50c) which rests 1 cell back. So I can update the death in both families,
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
User will choose a family.
From my Database each family has a unique number.
Based on The family chosen. I have created a range of all the names in the family using the inique family number, to update a death.
Because that person may have been part of other families through marriages each person has a unique ID.
Is there a way to get that ID which is located one col back from the name so I can update all the Deaths. The reason I need it is because the father and son may have the same name. Here is a picture of what I looking for. If Joe Jr Dies my Drop Down allow me to choose between Joe and Jean. I would like to know Joe jrs unique code (50c) which rests 1 cell back. So I can update the death in both families,
Id Code | Family/ Name | Bithday Anniversary | Death | Fam Code |
50 | Jones Joe & Jill | 01/01/1965 | 50 | |
50a | Joe | 02/01/1940 | 50 | |
50b | Jill | 02/01/1942 | 50 | |
50c | Joe | 03/01/1966 | 50 | |
50d | Johnny | 04/01/1970 | 50 | |
51 | Jones Joe & Jean | 07/07/1990 | 51 | |
50c | Joe | 03/01/1966 | 51 | |
51a | Jean | 07/10/1967 | 51 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>