>Bob,
>
>Actually checking the VFP 7.0 help file, it also does not support SELECT in the WHERE clause of the UPDATE command.

The funny thing is, since VFP support inline UDF's in select, he could actually do what he wanted by abstracting the sub query into a function call... like:

UPDATE MyTable
SET MyField = MyFunction(MyTable.PK)



Function MyFunction
LPARAMETERS iPK

SELECT TheValue FROM TheTable WHERE FK = iPK INTO CURSOR curTEMP

Return curTEMP.TheValue

BOb