Cannot edit member due to duplicate marriage record
When duplicate marriage records exist for a member, sometimes you cannot edit the member record. You will get an error message saying that the sacrament cannot be updated because the member belongs to an existing marriage record.
This happens because the member record always displays the sacrament record created last, which has a higher Sacrament DUID. If there is a duplicate record that was created earlier, with a lower Sacrament DUID, this record is causing the error message.
To address this issue:
- Look up both marriage records and find the one with the lower DUID.
- Uncheck the "Completed" box on this record.
- Now clear out any fields you can. Some cannot be cleared.
- Give the record an end date. Choose something like 1/1/1800 so it's appears as obviously fake.
Now you should be able to edit the member record without an error message.