My command button method scans one table which is related into another.

In the SCAN there is a case structure with a whole bunch of cases. The last defined case checks for a match in the related table and that an amount field in the table being scanned matches an amount field in the related table. The syntax is CASE FOUND([BanklineRds]) AND BanklineRds.SorderAmt = BankStatement.Amount. There is an OTHERWISE at the end.

Now when I set this running I find that it hardly ever runs this last case. However, if I press escape part way through and look in the debugger, I am finding that the CASE test returns .T. but the OTHERWISE is executed.

If I step through the program in the debugger, it works properly for every record.

I also find that if I run it several times in a row, it does a few more each time!!!

Can anyone suggest what is happening????

Thanks

Stewart