Our church is large enough that we have lots of families that attend where the husband and wife divorced and both remarried and both new families attend. When the parents check in their children for our children's ministry program or register them for something through weblinks, both families want the children on their household. So, we have children in the database that stay in the database, duplicated. We are looking for a correct way to assign a sub-status to these children so that our duplicate person can easily see on a substatus that they are in the described situation so they don't get merged anymore. I would like to hear how other churches handle these type situations or maybe what the status is that you use to define them. Thank you for any info you can provide!
Blessings!