After your 'Use pd_payments' statement, be sure you add the index statements
if !used('pd_payments')
use pd_payments
endif
select pd_payments
SET INDEX TO PD_PAYMENTS
SET ORDER TO 1
Of course, you'll change the name of the index to the correct one.
HTH
Barbara
>Thanks for the reply! I replace my USE statement with the code you indicated, but now I'm getting another error: "Table has no index order set" when the SET ORDER TO 1 command is run.
>
>>your select statement is using that table again.
>>try
>>
>>if !used('pd_payments')
>> use pd_payments
>>endif
>>select pd_payments
>>...