>UPDATE table1
>SET table1.field1 = table2.field2
>WHERE table1.key = table2.key
>
>So how do I do this?

>-Michelle

You can accomplish this by relating the two tables and then doing a replace...

select 0
use Table2
set order to tag PrimaryKey

select 0
use Table1
set relation to table1.key into table2

replace all table1.field1 with table2.field2

close all

BOb