>I have a parent table and a child table, I want to get a cursor using a SELECT command containing field1 from parent table and field1 from child table plus the record number for each child record found.
>
>Any suggestions? Thank you in advance.

---

If SQL has more than one table than recno() is not reliable. As a workaround you could do this :

luField1 = parent.field1
luPKvalue = parent.PKfield

select luField1 as ParF1,recno() as rcno, * from Child ;
 where Child.LinkField = luPKvalue ;
 into cursor myCursor

Cetin