Here's how to find orphaned Personal Profile records
Posted: Tue Jun 02, 2020 6:22 pm
I had a situation where going from a Personal Profile record to the Family record brought up an unrelated family. I used this script from Utilities > Database Manager to confirm that the Personal Profile was not linked to a Family (its mail_no field is empty). In this case, the Personal Profile was a duplicate, so I merged the orphan into the other record to fix the problem.
For more tips and tricks about using the Database Manager, see this thread:
viewtopic.php?f=1&t=13911
Code: Select all
select ma.mail_no, me.mail_no, me.pers_no, me.lastname, me.firstname
from me
left outer join ma on me.mail_no = ma.mail_no
where ma.mail_no is null
order by me.lastname, me.firstname
viewtopic.php?f=1&t=13911