I think it is very normal to copy an entire record given I just want to change the name of the unique-constraint column instead of having to insert all the values from scratch.

So it's not normal to have the #deleted happen after changing the duplicate name to a non-duplicate one .

I still cannot find a good explanation or workaround . Last thing attempted was doing a form requery which works but I can still see the #deleted record quickly appear then disappear which doesn't look good.

Any help with explanations/better workaround is much appreciated.