Hey there John good to see you here and VFPing.

You use the view name as the argument of the TableUpdate() call not the underlying tables on which the view is based.

>>You may not be using data buffering but the views is. Views are always buffered. Your last record doesn't get updat3ed because you never move off of it. The view is in record buffering and it does an implicit TableUpdate when you move off of a record. You need a TableUpdate to update the last record.
>>
>>It would probably be easier to use buffering all around and do the TableUpdates for all of the records. At least then you won't have the last records acting differently than the others.
>
>Jim, can you help me understand the flow and usage of tableupdate()? I seem to have more difficulty now<g>. I keep getting errors saying that I have uncommited changes in so&so table. I have tried all the ways I can think of to implement the tableupdate() function. Also it does not close some of the tables when I close the form now...