>>>You would think, FoxPro would be smart enough to find the record with the Key, then check for conflicts... rather than just building such an ungly update statement.
>>>
>>>Perhaps someone close could mention this to Randay Brown or Calvin Hasia... I
>>am sure they could fix it!
>>>
>>>BOb
>>
>>
>>Thanks for the explanation.
>>
>
>So did making the WHERE type change fix your performance problem?
>
>BOb

Yes. Modifying the Where settting so only the Key is in the Where clause fixed the problem. I just wonder why it defaults to such an ugly setting. Anyway, it works great now.

Thanks,
Tom