>>Thanks, that helps a lot. I notice in the help file for TableUpdate that the first paramater is a logical. What do the 0 & 2 do in your example?
>>
>>Thanks
>
>John,
>
>You must be using VFP 3.0 then. The first argument was logical in VFP 3.0, VFP 5.0 supports both the 3.0 logical arguments or the newer numeric arguments which provide finer control over how multiple records will be updated.

Yep, I am using 3.0, till 6 comes out.

Thanks