ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 320
- Office Version
- 365
- 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,
[TABLE="width: 418"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Id Code
[/TD]
[TD]Family/ Name[/TD]
[TD]Bithday Anniversary[/TD]
[TD]Death
[/TD]
[TD]Fam Code[/TD]
[/TR]
[TR]
[TD]50
[/TD]
[TD]Jones Joe & Jill[/TD]
[TD="align: right"]01/01/1965[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]50a
[/TD]
[TD]Joe[/TD]
[TD="align: right"]02/01/1940[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]50b[/TD]
[TD]Jill[/TD]
[TD="align: right"]02/01/1942[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]50c[/TD]
[TD]Joe[/TD]
[TD="align: right"]03/01/1966[/TD]
[TD][/TD]
[TD="align: right"]50
[/TD]
[/TR]
[TR]
[TD]50d[/TD]
[TD]Johnny[/TD]
[TD="align: right"]04/01/1970[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]51[/TD]
[TD]Jones Joe & Jean[/TD]
[TD="align: right"]07/07/1990[/TD]
[TD][/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]50c
[/TD]
[TD]Joe
[/TD]
[TD="align: right"]03/01/1966
[/TD]
[TD][/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]51a[/TD]
[TD]Jean[/TD]
[TD="align: right"]07/10/1967[/TD]
[TD][/TD]
[TD="align: right"]51
[/TD]
[/TR]
</tbody>[/TABLE]
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,
[TABLE="width: 418"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Id Code
[/TD]
[TD]Family/ Name[/TD]
[TD]Bithday Anniversary[/TD]
[TD]Death
[/TD]
[TD]Fam Code[/TD]
[/TR]
[TR]
[TD]50
[/TD]
[TD]Jones Joe & Jill[/TD]
[TD="align: right"]01/01/1965[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]50a
[/TD]
[TD]Joe[/TD]
[TD="align: right"]02/01/1940[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]50b[/TD]
[TD]Jill[/TD]
[TD="align: right"]02/01/1942[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]50c[/TD]
[TD]Joe[/TD]
[TD="align: right"]03/01/1966[/TD]
[TD][/TD]
[TD="align: right"]50
[/TD]
[/TR]
[TR]
[TD]50d[/TD]
[TD]Johnny[/TD]
[TD="align: right"]04/01/1970[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]51[/TD]
[TD]Jones Joe & Jean[/TD]
[TD="align: right"]07/07/1990[/TD]
[TD][/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]50c
[/TD]
[TD]Joe
[/TD]
[TD="align: right"]03/01/1966
[/TD]
[TD][/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]51a[/TD]
[TD]Jean[/TD]
[TD="align: right"]07/10/1967[/TD]
[TD][/TD]
[TD="align: right"]51
[/TD]
[/TR]
</tbody>[/TABLE]