>Hi Chris
>I do have table buffering set on both the table and the view.However what I am trying to do is update the record I am currently on in my view. its not updateing to the main table

Are you sure it is not updating the main table? I had this problem, and I would run my form, issue the tableupdate on the view, then use the Data Session window to see the updated data in the table. But when I closed the form and opened the table, the updated data was not there. I needed to issue a tableupdate not only on the view, but also the table.

Failing that, what return value are you getting when you issue the tableupdate? Also, I think a tablueupdate is automatically issued when you are in pessimistic buffering mode if you move the record pointer. Could that be the case, that the record pointer is moved, and VFP is issuing a tablueupdate by itself with no indication that the update failed?