Hi Jeff,

The Reply from Mark fixed it for me, but I'll take your advise also. Thanks to both of you.

>Alan,
>
>If you have both the table and the view buffered you have to do a tableupdate() on both. The best way to do this is to buffer your view and leave the table itself unbuffered. Then the tableupate on the view will update the actual table.
>
>HTH
>
>Jeff
>
>>Hello,
>>I working with a Local View for the first time and I'm running into a problem with the update. After I issue my TableUpdate() the new record seem to be there. I can recall it and edit it. When I exit the application, then go back in, it's gone! I'm using VFP 6.0 SP3. I have both the table and the view set-up ad 3-Optimistic Row Buffering. I've tried it with 5-Optimistic Table Buffering also. It seems that the View creates a temporary file, but it is never written back to the table. I have a primary key and all of the fields are marked for update in the View designer.
>>
>>What am I doing wrong?
>>TIA