* query for records with duplicate parents after merging

[fasol]

As a result of a previously performed merging process, a number of people in my file were left with duplicate parents (visible via the 'all'-tab). This happens when you merge 2 people into 1, but FH has not recognized the parents as identical people. I want to correct these situations manually, but my file is large (85,000 records); That's why I would like to do a query for individuals who have double parents in their record. Is there a way to do this, possibly with a plugin? Thanks!
Peter

[jelv]

Try this query

[tatewise]

Welcome to your first FHUG question Peter.

For future reference, when merging 2 Individuals, it should be possible to extend the merge to include immediate relatives linked via the Parents family and Spouse family links that you can see on the All tab.

It is straightforward to create a Query to find Individual records that have two or more Parents family links, i.e. %INDI.FAMC[2]% exists. Alternatively, use the one attached by John, but I thought you might like to experiment yourself.

In the Query Columns tab use the Fields to add a Family as Child item but for instance [2] as shown below.
Then on the Rows tab add a filter to exclude Individuals where that 2nd link is missing.

image.png (92.15 KiB) Viewed 409 times

image.png (28.93 KiB) Viewed 409 times

[fasol]

Thank you, this is what i looked for!

Best,

Peter