>Hi.
>Is it possible to update a table's field from another one's? I mean, something like... (I know this doesn't work, ok??)
>
>update mytable set myfield = othertable.otherfield where othertable.keyfield=mytable.keyfield
>
>Thanks a lot in advance...
It works just as you write but you need to select othertable and if would scan the table:
select othertable
scan
update mytable set myfield = othertable.otherfield ;
where othertable.keyfield=mytable.keyfield
endscan
Replace is easier.
select myTable
replace myfield with othertable.otherfield ;
for seek(mytable.keyfield,'othertable','keyfieldtag')
Cetin