>Hi Barbara,
>
>Long time no see!
>
>I have a similar problem with deleting a record, but from a buffered data environment in my form. I created a new record. I save the new record with TableUpdate. I then want to delete it. The buffering is set to 2-Pessimistic Row Buffering. When I use the PACK command, the record will seem to be deleted, because my record count even changes from 3608 to 3607. However, when I exit the form and come back, my record count is now 3608, and the deleted record is back. I have a flag set to make a label called lblDeleted display the caption of "Deleted", if a record is marked for deletion. Well, the record is certainly there. Why is it not really deleted after the PACK command?
>
>Do I need to set the table cursor to a different buffering mode or turn it off, or what? Do I need to save the deletion, then PACK the table?
>
>Cecil

I think you should apply the PACK to the table, not to the view. And usually you would do the PACK only once a month or so.

In the view, all you need to do is delete, followed by TableUpdate().

Hilmar.