* Check for Unlinked Relatives or Individuals

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
avatar
BobWard
Superstar
Posts: 402
Joined: 18 Nov 2012 01:50
Family Historian: V6.2
Location: Fountain Hills, Arizona, USA

Check for Unlinked Relatives or Individuals

Post by BobWard » 12 Jan 2020 20:51

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.
Last edited by BobWard on 12 Jan 2020 21:11, edited 1 time in total.

avatar
MB@RE
Diamond
Posts: 56
Joined: 14 Sep 2013 11:04
Family Historian: V7
Location: Warwickshire

Re: Check for Unlinked Relatives or Individuals

Post by MB@RE » 12 Jan 2020 21:11

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'.
Mike Burditt researching BURDITTs of Leic/Northants and WEBSTERs of Lancs

avatar
BobWard
Superstar
Posts: 402
Joined: 18 Nov 2012 01:50
Family Historian: V6.2
Location: Fountain Hills, Arizona, USA

Re: Check for Unlinked Relatives or Individuals

Post by BobWard » 12 Jan 2020 21:15

MB@RE wrote:
12 Jan 2020 21:11
Those not in Pool 1, should be orphans.
Agree, that seems to match the results that I got using the Search for Orphans query.

I think I have answered my question. Thanks.

User avatar
tatewise
Megastar
Posts: 24392
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Check for Unlinked Relatives or Individuals

Post by tatewise » 12 Jan 2020 22:35

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.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
dbnut
Famous
Posts: 123
Joined: 05 Sep 2013 20:12
Family Historian: V7
Location: Isle of Wight, UK

Re: Check for Unlinked Relatives or Individuals

Post by dbnut » 15 Jan 2022 21:56

MB@RE wrote:
12 Jan 2020 21:11
Create a new individual query.
On line two add : "=RelationPool(%INDI%)"
Those not in Pool 1, should be orphans.
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"

User avatar
LornaCraig
Megastar
Posts: 2502
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Check for Unlinked Relatives or Individuals

Post by LornaCraig » 16 Jan 2022 01:00

MB@RE wrote:
12 Jan 2020 21:11
Create a new individual query.
On line two add : "=RelationPool(%INDI%)"
You don't need to create a custom query. Just use the standard query called Search for Orphans.
Lorna

User avatar
dbnut
Famous
Posts: 123
Joined: 05 Sep 2013 20:12
Family Historian: V7
Location: Isle of Wight, UK

Re: Check for Unlinked Relatives or Individuals

Post by dbnut » 16 Jan 2022 08:38

LornaCraig wrote:
16 Jan 2022 01:00
MB@RE wrote:
12 Jan 2020 21:11
Create a new individual query.
On line two add : "=RelationPool(%INDI%)"
You don't need to create a custom query. Just use the standard query called Search for Orphans.
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.

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"

User avatar
LornaCraig
Megastar
Posts: 2502
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Check for Unlinked Relatives or Individuals

Post by LornaCraig » 16 Jan 2022 10:57

Paul, my comment was meant for MB@RE, who had suggested creating a custom query which is not necessary.
Lorna

User avatar
dbnut
Famous
Posts: 123
Joined: 05 Sep 2013 20:12
Family Historian: V7
Location: Isle of Wight, UK

Re: Check for Unlinked Relatives or Individuals

Post by dbnut » 16 Jan 2022 11:05

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.
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? :oops:
Paul White
"Family Historian is not just for Christmas, but for Life"

Post Reply