Hello Barbara,

>Steve, your select returns a cursor/query, not a number. Is this your exact code?
>>

>>UPDATE vueOrdLines ;
>>SET iQty = ;
>>	(SELECT MAX(iQty) from vueOrdLines)
>>WHERE ...
>>

Yes, this is the exact syntax that I was trying. When I highlight the SELECT portion of the code and tell fox to execute the selection, it does return one number. I can run an almost identical query in SQL Server and it's perfectly happy. Unfortunately the info in the help file on the UPDATE-SQL command is really thin on the ground and the example is very simple. I suppose the crux of my question is can I embed a SELECT statement in an update statement? Maybe this is a really obscure requirement?