I am trying to find a way to check my database to see if there are any people there who may have been inadvertantly, or intentionally, unlinked from my family tree, i.e., I am looking for any "orphans".
I thought there was a Plug-In to do this, but I was unable to find one. Is there an easy way to identify any potential orphans that may be hiding in my database?
Note: I did run the standard query "Search for Orphans", but it seemed to return everyone in my database. Five people had a Pool number of 2, while the remainder had a Pool number of 1. Not quite sure as to how to interpret this result. Does a Pool number of 2 mean that there is no relationship to anyone else in the family tree?
Update: I pulled up the profiles for all the people who were in Pool 2. It does appear that they have no relational connection to anyone else in the family tree. So, I think I have confirmed that anyone in Pool 2 does not belong in the family tree.
* Check for Unlinked Relatives or Individuals
-
- Superstar
- Posts: 420
- Joined: 18 Nov 2012 01:50
- Family Historian: V6.2
- Location: Mesa, Arizona, USA
Check for Unlinked Relatives or Individuals
Last edited by BobWard on 12 Jan 2020 21:11, edited 1 time in total.
Re: Check for Unlinked Relatives or Individuals
Create a new individual query.
On line two add : "=RelationPool(%INDI%)"
Those not in Pool 1, should be orphans.
I found this by going on the 'Help menu'.
On line two add : "=RelationPool(%INDI%)"
Those not in Pool 1, should be orphans.
I found this by going on the 'Help menu'.
Mike Burditt researching BURDITTs of Leic/Northants and WEBSTERs of Lancs
- tatewise
- Megastar
- Posts: 28449
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Check for Unlinked Relatives or Individuals
Pool numbers indicate family groups.
Everyone in the same Pool are either directly related or related by marriage.
Anyone in one Pool is totally unrelated to anyone in a different Pool.
The Search for Orphans Query lists records in their Pools.
Anyone in a unique Pool is and individual orphan.
Pool number 1 is usually the largest main Pool including the File Root.
Everyone in the same Pool are either directly related or related by marriage.
Anyone in one Pool is totally unrelated to anyone in a different Pool.
The Search for Orphans Query lists records in their Pools.
Anyone in a unique Pool is and individual orphan.
Pool number 1 is usually the largest main Pool including the File Root.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Check for Unlinked Relatives or Individuals
Just noticed this and prompted to mention I find it very useful to have a first "custom" column in the Individual Records Window with Heading "Pool" and Expression as you quoted.
Any time we want to check for oddities, sort descending on that column.
Paul White
"Family Historian is not just for Christmas, but for Life"
"Family Historian is not just for Christmas, but for Life"
- LornaCraig
- Megastar
- Posts: 3208
- Joined: 11 Jan 2005 17:36
- Family Historian: V7
- Location: Oxfordshire, UK
Re: Check for Unlinked Relatives or Individuals
You don't need to create a custom query. Just use the standard query called Search for Orphans.
Lorna
Re: Check for Unlinked Relatives or Individuals
Lorna, I didn't say I needed (or wanted) a custom (or any other kind of) query. Just a tip to point out the benefit of a (1-minute) addition to columns in the Records Window.LornaCraig wrote: ↑16 Jan 2022 01:00You don't need to create a custom query. Just use the standard query called Search for Orphans.
Also could have been more explicit to say "Pool Number always has high visibility" and note that "multi-select can efficiently add small-pool individuals to Named Lists". And for those who have never heard of RelationPool before, another opportunity for a chance encounter - in a topic that could easily match their search criteria.
But mainly how I'm just a happy boy to be able to rely a teeny bit less (in one particular area) on a/the custom or standard query route. I'm always pleased to have shortcuts.
Paul White
"Family Historian is not just for Christmas, but for Life"
"Family Historian is not just for Christmas, but for Life"
- LornaCraig
- Megastar
- Posts: 3208
- Joined: 11 Jan 2005 17:36
- Family Historian: V7
- Location: Oxfordshire, UK
Re: Check for Unlinked Relatives or Individuals
Paul, my comment was meant for MB@RE, who had suggested creating a custom query which is not necessary.
Lorna
Re: Check for Unlinked Relatives or Individuals
Sorry, Lorna, too dozy to notice whom you quoted. Too inclined to jump back in when I think anyone's disagreeing. Any tips on how an opinionated old **** could mend his ways?LornaCraig wrote: ↑16 Jan 2022 10:57 Paul, my comment was meant for MB@RE, who had suggested creating a custom query which is not necessary.
Paul White
"Family Historian is not just for Christmas, but for Life"
"Family Historian is not just for Christmas, but for Life"