Add NOT DELETED() as a filter expression for your candidate key index.
>I am using remote views through ODBC connections. I am having problem when deleting records. When I delete an inventory item & then go back & add the same item again I get Uniquenesssssss... of key field error on the candidate key which is the item number.
>
>Before deletion, I replaced the item# with SYS(2015), do the TABLEUPDATE & then delete the record & do the TABLEUPDATE again. It works, but does someone knows an easier way to acomplish the same thing. Thanks In Avance..
>
>Best Regards!
>
>
>Raz
- Jayesh