Dear Reza,
Use local view, and left join on acode (primary key) of both tables, this way you can update both table.
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************