Shuli,

Are checks and app already open before the select runs?

Do you have some index expressions that are not simple field expressions on either of the two tables?

>Whenever I run the following select statement I get the error "TABLE HAS NO INDEX ORDER SET."
>What is wrong with the query? 'lnStart' is a unique check number. Any help would be appreciated. TIA.
>
>SELECT checks.*, ;
> app.sa_num, app.title_num, app.county, app.section, app.block, app.lot ;
> from checks ;
> INNER JOIN app ON app.sa_num==checks.sa_number;
> WHERE checks.chkno==lnStart ;
> INTO CURSOR curCheckToPrint