>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