* Progenitor, Finding
- Gary Carson
- Famous
- Posts: 162
- Joined: 02 Mar 2016 17:46
- Family Historian: V7
- Location: Grand Island, Nebraska, USA
Progenitor, Finding
Is there query method to find each progenitor in a project?
Gary
Win 10, FH 7.0.15
Win 10, FH 7.0.15
- tatewise
- Megastar
- Posts: 28410
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Progenitor, Finding
I think you need to define precisely what you mean by "progenitor".
One definition is "an ancestor or parent".
But ancestor of who? File root or anyone else?
Perhaps you mean anyone who has children.
Perhaps you mean earliest progenitors who themselves have no ancestors.
There are just too many ways of interpreting that word, and for a Query to list what you want, the criteria must be precise.
If you want earliest progenitors who have no parents but do have children then the Row filters of an Individual Query are:
Exclude unless %INDI.~FATH[1]>% is null
Exclude unless %INDI.~MOTH[1]>% is null
Exclude if %INDI.~CHIL[1]>% is null
But that will still include people who have a Spouse with Parents, so hopefully you see what I mean about preciseness.
One definition is "an ancestor or parent".
But ancestor of who? File root or anyone else?
Perhaps you mean anyone who has children.
Perhaps you mean earliest progenitors who themselves have no ancestors.
There are just too many ways of interpreting that word, and for a Query to list what you want, the criteria must be precise.
If you want earliest progenitors who have no parents but do have children then the Row filters of an Individual Query are:
Exclude unless %INDI.~FATH[1]>% is null
Exclude unless %INDI.~MOTH[1]>% is null
Exclude if %INDI.~CHIL[1]>% is null
But that will still include people who have a Spouse with Parents, so hopefully you see what I mean about preciseness.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- Gary Carson
- Famous
- Posts: 162
- Joined: 02 Mar 2016 17:46
- Family Historian: V7
- Location: Grand Island, Nebraska, USA
Re: Progenitor, Finding
Point well taken, you were right about the need to define more precisely. You did hit on exactly what I was trying to accomplish.
Gary
Win 10, FH 7.0.15
Win 10, FH 7.0.15
- Gary Carson
- Famous
- Posts: 162
- Joined: 02 Mar 2016 17:46
- Family Historian: V7
- Location: Grand Island, Nebraska, USA
Re: Progenitor, Finding
How do I set filter to exclude unless both father and mother are null?
Gary
Win 10, FH 7.0.15
Win 10, FH 7.0.15
- tatewise
- Megastar
- Posts: 28410
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Progenitor, Finding
Use the filters I posted.
The first filter excludes everyone who has a Father.
The second filter excludes everyone from that list who has a Mother.
So what is left is people with neither.
The first filter excludes everyone who has a Father.
The second filter excludes everyone from that list who has a Mother.
So what is left is people with neither.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry