>>Dear Reza,
>>
>>Use local view, and left join on acode (primary key) of both tables, this way you can update both table.
>
>Dear Aaron,
>I have not any Database .i use from free table. how must i do it?
>thanks

You can create views that use free tables, and you can create the DBC and views on-the-fly. Do something like this:

create database MyViews
create SQL View "SomeView" AS ;
   Select Table1.Field1, Table1.Field2, Table2.Field1 ;
      FROM Table1 ;
         INNER JOIN Table2 on Table1.Field1 = Table2.Field1 ;
      WHERE SomeCondition

When you're done, you can delete the whole thing:

SET DATABASE TO MyViews
CLOSE DATABASE
DELETE FILE MyViews.dbc
DELETE FILE MyViews.dc?