This problem was first reported in 4.0.57.30 under ticket 9954

We have a custom table attached to client details which we have configured to allow only one record. The table has a single field.

Both copies of the client had the same value set for the field prior to merging. As a result, the field / value is linked twice to the merged client, even though the table only allows one record.

I am able to remove one of the values under the admin account by temporarily changing the Custom Table to allow multiple records, which then gave me the individual edit and delete options for each record.

As of 4.0.60.3, we are now seeing multiple records in a single value table that is attached to the Admissions module. We have no idea how these are being created, it’s likely not from a merge as it was in the previous case with the client details custom table. We have seen this happen twice recently, and it breaks our custom report since it should be impossible to have multiple values in these fields due to the custom table configuration.

When you try to edit, it picks the top one and the other one has no way to edit or delete. The workaround is to change the Allow Multiple Values setting to Yes, which changes the interface to have the edit / delete button on every row, instead of a single edit button that only allows you to bring up one of them for editing, and no delete button.