That makes sense. But it still seems odd to me that it would complain even though the 'duplicate' record was tagged for deletion. I even tried putting a filter on the primary index for NOT DELETED(). Guess I'll have to bite the bullet and implement a good table design. :) Thanks for your help!


>Beth,
>
>Uniqueness of indexes and valid rules on fields and records are evaluated when you update the buffer. You need to insure that the PK memvar is unique before you issue the INSERT INTO to avoid the error.