>UPDATE moneyfields SET ttladjusts = ;
>        (SELECT query.adjusts FROM query JOIN moneyfields ON VAL(query.control) = VAL(moneyfields.control))
>
>Perhaps needless to say - this does not run. An error is generated of the form "Function name is missing )".
>
>Any suggestions please? /psb
> 

The typical fox way is to use a replace with a seek, e.g.

select query
index on val(control) tag tag1
select moneyfields
replace ttladjusts with query.adjusts ;
  for seek(val(moneyfields.control), "query", "tag1") ;
  in moneyfields