I'm having a similar problem that's causing me much grief! I have a view based on local tables. I set the buffering of the view to '5', turn SendUpdates on, fill in some information like who deleted the record and when, and delete the record. I then issue a TableUpdate(2). The TableUpdate does not generate an error but the record in the base table is not deleted! The base tables have buffering set to '1'. What am I doing wrong?

Thanks for any help-

>Hi Mark, Sarah ----
>
>To add to Marks reply, ensure that you *don't* buffer the base tables and only buffer the view. All Tableupdates and Tablereverts should be performed on the view only. Don't use the base tables as controlsources or otherwise refer to them directly.
>
>The precise reason why your code didn't work is that you are updating the base tables *before* the view has been updated and the view contains the deletions that have not been applied to the base tables.
>
>>>I have a view call ventry based upon the entry table and it's child, entrydet.
>>>The contents are shown in a grid and I found it necessary to delete records from the view and use tableupdate to pass the deletion down to the table. PROBLEM - the deletion is only temporary. When the user leaves the form and returns the records are still there. Any ideas?
>>>
>>>

delete from bkdata!ventry where entryid = m.lckeyvalue
>>>select entrydet
>>>=tableupdate(.t.)
>>>select entry
>>>=tableupdate(.t.)

>>>
>>>with fingers crossed - Sarah
>>
>>You need to be SELECTed to the View's workarea not the table the view is derived from. Issue TableUpdate() on the view.