I am sorry, I misunderstood your first post. What you describe makes sense. That's the tipical VFP behavior.

Is there any chance that you can blank the deleted record (or change its values in some form) before deleting it so that the key is not longer duplicated?

>Hello,
>
>I´m using Tableupdate() after deleting the record from the view, but after tableupdate() the record still marked for deleted in the base table, because they are free tables (.DBF in VFP), so, when i insert a new record with the same index key i have a error message (Duplicate Record) because this record still exist in the base table but marked to deleted.
>
>Thanks again
>Carla