* Children with multiple parents

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
User avatar
RogerF
Famous
Posts: 182
Joined: 26 Apr 2009 16:32
Family Historian: V6.2
Location: Oxfordshire, England
Contact:

Children with multiple parents

Post by RogerF » 14 Sep 2017 11:18

Is is possible to write a query which reports INDI records having more than one FAMC element?
Roger Firth, using FH to research the FIRTHs of Lancashire and Yorkshire, and the residents of the market town where I live.

User avatar
PeterR
Megastar
Posts: 1059
Joined: 10 Jul 2006 16:55
Family Historian: V6.2
Location: Northumberland, UK

Re: Children with multiple parents

Post by PeterR » 14 Sep 2017 11:27

Yes. Use the following Filter:

Code: Select all

Add unless %INDI.FAMC[2]>% is null
Peter Richmond (researching Richmond, Bulman, Martin, Driscoll, Baxter, Hall, Dales, Tyrer)

User avatar
Jane
Site Admin
Posts: 7867
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Children with multiple parents

Post by Jane » 14 Sep 2017 11:29

That's easy, just do an individual query and add a filter with

Exclude if
%INDI.FAMC[2]>% is null

edit: SNAP
Attachments
Two or more Family As Child links.fhq
(622 Bytes) Downloaded 44 times
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

User avatar
RogerF
Famous
Posts: 182
Joined: 26 Apr 2009 16:32
Family Historian: V6.2
Location: Oxfordshire, England
Contact:

Re: Children with multiple parents

Post by RogerF » 14 Sep 2017 13:31

Thank you both; it was the ">" that I forgot about.
Roger Firth, using FH to research the FIRTHs of Lancashire and Yorkshire, and the residents of the market town where I live.

User avatar
tatewise
Megastar
Posts: 17321
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Children with multiple parents

Post by tatewise » 14 Sep 2017 13:58

Roger, that warrants two comments:
  1. The ">" actually makes no difference! Works exactly the same without or without.
  2. Use the [...] to right of Expression: box to open the Data Reference Assistant and select Family as Child> to obtain the element reference, then edit the [1] into [2] to specify the 2nd instance.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

Post Reply