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:
- The ">" actually makes no difference! Works exactly the same without or without.
- 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.