Hash Deleted

[Shaimaa T]

Hi all,

When I copy an entire record and paste it in a new record , I first get a duplicate issue with one of the columns(unique key constraint) and when I attempt to change the column value so as not to be duplicate ...I get a #deleted for the whole record.

This does not happen when I copy the unique column from a record and paste it then change (copying that column alone).

What could be the best explanation for this and how can I attempt this issue?

 

[jdraw]

When you copy and paste, you are trying to add a record with an already existing value in the unique key field. "Unique" is the issue, since you are trying to add a duplicate.
So if you add a new record --a new unique key, the you can update this newly created record, since it is unique.

 

[Shaimaa T]

How can I resolve this issue since after I get a message box that I cannot insert duplicate trial code(the unique column) and I try to change it to something unique, the whole record is hash deleted.