Page 1 of 1

Children with multiple parents

Posted: 14 Sep 2017 11:18
by RogerF
Is is possible to write a query which reports INDI records having more than one FAMC element?

Re: Children with multiple parents

Posted: 14 Sep 2017 11:27
by PeterR
Yes. Use the following Filter:

Code: Select all

Add unless %INDI.FAMC[2]>% is null

Re: Children with multiple parents

Posted: 14 Sep 2017 11:29
by Jane
That's easy, just do an individual query and add a filter with

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

edit: SNAP

Re: Children with multiple parents

Posted: 14 Sep 2017 13:31
by RogerF
Thank you both; it was the ">" that I forgot about.

Re: Children with multiple parents

Posted: 14 Sep 2017 13:58
by tatewise
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.