>Has anyone seen this behavior?
>
>
>I have a CANDIADTE KEY on a customer table called cust_id
>
>if I delete it, and set deleted on VFP3 still takes it into account when
>appending new records and I always get the great message
>
>INDEX KEY VIOLATED....
>
>Does anyone know why? or how to fix it or get around it?
>
>
>Thanx a lot.
>Alfred

I'm hazarding a guess here... This is possibly due to the fact that the tag does NOT physicall get deleted but is hidden (in fact it will still be updated creating greater overhead).
Try deleting the CDX file physically, then USE the file (you will get the error "CDX file not found"; ignore so that the reference to it is removed, and then rebuild the necessary tags.

Ashley