Page 1 of 1

Using Relationship to Parents in queries

Posted: 11 Nov 2022 10:26
by Little.auk
How do I add a "Relationship to Parents" column to a query (i.e. b= birth, a= adopted etc)
I can't find the field in the query "Fields" list, and I haven't been able to find the correct field name in the knowledge Base to be able to add it manually.

Re: Using Relationship to Parents in queries

Posted: 11 Nov 2022 10:43
by ColeValleyGirl
Try

Code: Select all

%INDI.FAMC[1].PEDI[1]%
Configuring the Record window, I found it by selecting <Other...> when configuring columns and then Insert Data Ref and browsing the reference tree.

In a query, you're looking for (Relationship) under Family as Child.

Re: Using Relationship to Parents in queries

Posted: 11 Nov 2022 11:34
by Little.auk
Thanks - I should have seen that!

Re: Using Relationship to Parents in queries

Posted: 11 Nov 2022 11:52
by ColeValleyGirl
If an individual has more than one set of parents, you'll need more than one column, e.g.

Code: Select all

%INDI.FAMC[1].PEDI[1]%
%INDI.FAMC[2].PEDI[1]%