Jump to content
TNG Community

Report of children with multiple parents


Horsman_ONS

Recommended Posts

Somehow I managed to get a child attached to two sets of parents. One was correct and the other totally wrong.  I have unlinked the child from the incorrect parents, but would like a report which would show if I have any other instances of this.  So  has anyone created a report showing children with more than one set of parents ?    Its not a problem if it  picks up 'adopted parents'

Thanks

 

Link to comment
Share on other sites

I've just found the report I needed within Wiki / Reports / Maintenance Reports. 

People marked as natural child of more than one family

I copied the sql code, amended the database id, and it works

 

 

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...