This works fine:

Select Table1
Scan FOR owe <>0
Endscan

It goes through all the records and exits when reaching the end of the table. So it looks like the problem is when SELECTing TABLE2 and working with it. Would this mean that the index on TABLE2 is corrupted? If so, how to fix it?

TIA

Ulises