>Hi Edward, Thank you.
>Yes, I mean that I've checked the 'Send SQL updates'(I use Chinese version VFP 5) checkbox. and the view is a local view, It join two tables but I just want to update only one of them.
>Thanks again.

Jack, I don't know why it does not work, but I guess you could go step by step, i.e. create view for one table, make sure that it updates the table, and then extend it to the second table. Hopefully, you will catch something along this way.