Of course it works that way. The others have posted the theory here, so I won't repeat it. Just a shorthand workaround:
SELECT *, RECNO() AS CustRecNO;
FROM customer Cust;
WHERE Cust.custid = "001" ;
INTO Cursor Tmp1
SELECT tmp1.*, < ord.somefield(s) >;
FROM Tmp1 Cust, order Ord;
WHERE Cust.custid = ord.custid AND ;
Ord.orderid < "999"
Now the final cursor will have the CustRecNo properly filled. Recno() in SQL select works on single table queries only.
Dragan,
Thanks. Like all good explanations, the answer is obvious when explained well.
Regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.