>Hello,
>In a table, I am deleting records with a field called "press",
>i.e. delete for machines where press = deletepress
>
>Later on down the line, if the user decides to add the machine back in, I get
>an error "uniqueness of machine is violated" even though, when I browse the table, that machine appears to no longer be present.
>
>Help?
>Thanks in advance.

Hi Joseph,

Is machine your unique key field? The key must be unique including the deleted records, as they still stay in the table. You should consider using the surrogate (meaningless) keyfield for your Primary key.