I recently ran a Standard query 'Orphans'
I was amazed to find so many in my database and duly investigated.
According to help menu an orphan is someone who has not been linked to 3 other persons.
In many of 'my orphans' they are linked by birth to a father and mother and other reports show as such
How do I prevent these orphans showing as my inclination is an orphan is/was without parents.
I have checked the relationships and they do show an orphan with a mother and father.
I see you can add a relationship a,b,etc...what is the point of this with birth if you have linked a child to its 2 parents??
Is there a query which can be run to show the relationship settings ( ie a b, etc) of all persons in database?
Thanks
ID:5426
* Orphans
- jsphillips
- Megastar
- Posts: 579
- Joined: 13 Aug 2006 16:00
- Family Historian: V6.2
- Location: Near Sevenoaks Kent
- Jane
- Site Admin
- Posts: 8440
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Orphans
I presume you mean the Search for Orphans query, if you read the introduction for that you will find it actually shows people in their 'pools'
If you want to search for people with no mother or father simply create a new query
Add if Father (%INDI.~FATH[1]>%) is null
Exclude unless Mother (%INDI.~MOTH[1]>%) is null
The purpose of the relationship against children is to show partial/non blood relationships such as adoption, step families etc.
If you want to search for people with no mother or father simply create a new query
Add if Father (%INDI.~FATH[1]>%) is null
Exclude unless Mother (%INDI.~MOTH[1]>%) is null
The purpose of the relationship against children is to show partial/non blood relationships such as adoption, step families etc.
- jsphillips
- Megastar
- Posts: 579
- Joined: 13 Aug 2006 16:00
- Family Historian: V6.2
- Location: Near Sevenoaks Kent
Orphans
Thank you Jane
Yes I did read about pools.
What is the point then of the Orphans query ??
I thought it would return a result of children with either no parents or only one parent.
To write a new query as suggested what rows and what columns are required please
Thanks
Yes I did read about pools.
What is the point then of the Orphans query ??
I thought it would return a result of children with either no parents or only one parent.
To write a new query as suggested what rows and what columns are required please
Thanks
- johnmorrisoniom
- Megastar
- Posts: 882
- Joined: 18 Dec 2008 07:40
- Family Historian: V7
- Location: Isle of Man
Orphans
The term 'Orphan' can have many meanings. The genealogical one, whicj is the one you are referring to, is a child that has lost it's parents. The FH query is using the 'Publishing' meaning, that is to say, Persons who are not linked to others in your tree. In the query results window you will see a pool number. The root person and all connected to them are in pool 1. Any one else connected to each other, but not to the root, would be in pool 2, 3 etc.
In publishing there are 'Orphans and widows'. These are lines of text that are out of place, like a heading on it's own at the bottom of a page (Widow) and the correspondg text without the heading (Orphan) at the top of the next page.
John
In publishing there are 'Orphans and widows'. These are lines of text that are out of place, like a heading on it's own at the bottom of a page (Widow) and the correspondg text without the heading (Orphan) at the top of the next page.
John
- jsphillips
- Megastar
- Posts: 579
- Joined: 13 Aug 2006 16:00
- Family Historian: V6.2
- Location: Near Sevenoaks Kent
Orphans
Thanks Yes
Columns I said Individual ie %INDI%
I take it that brings all persons into the database
Columns I said Individual ie %INDI%
I take it that brings all persons into the database