>
>     SELECT RECNO() FROM customer ;
>         WHERE customer.custid = "001"
>
><\PRE>
>to get a handy list of pointers to records in customer.dbf.
>
>But if I use 

>
>     SELECT RECNO() FROM customer, order ;
>          WHERE customer.custid = "001" .AND. ;
>                order.orderid < "999"
><\PRE>
>it selects the RECNO() from order .dbf.
>
>If I use 

>
>     SELECT RECNO() FROM order, customer ;
>         WHERE order.orderid < "999" .AND. ;
>               custoemr.custid = "001"
><\PRE>
>it still selects the order.dbf record number.
>
>How do I tell a SQL SELECT statment which table I want to selct the RECNO() from?
>
>Any ideas?
>
>Regards,

RECNO() is not reliable when SELECTing from multiple tables. This is documented in Help.

Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer