Gerard,
You can also use indexseek() especially if you are only doing an existence check and don't actually need to move the record pointer in the lookup table before you dosomething.
>Thanks Sergey for your reply.
>I have recreated the indexes and will check this evening if this sorts the problem.
>If it was a corrupt index, I would have expected to see more (rathet than very intermittent) problems
>>In my experience only corrupted indexes could cause incorrect SEEK results.
>>
>>BTW, you can shorten code by using SEEK() function
>>
>>IF SEEK(Cur.MyField, "MyLookup", "MyOrder")
>> Do something
>>ENDIF
>>