>Hi. I have a form that has a print button. I want to print the current record.
>I put: REPORT FORM myreport TO PRINT NEXT 1, but it only printed 1 child record.
>I even tried: SET SKIP TO child_dbf before my print command, to no avail.
>
>I hear the preferred way is a private environment in the report wirter. BUT how do would you set the record pointer??
>
>Thanks, Randy
Hi, maybe this will help too
Solution 1
SELECT childtable
REPORT FORM reportfrxname TO PRINTER FOR childtable.keyvalue=parenttable.keyvalue
Solution 2
SELECT * FROM parenttable JOIN childtable ON parenttable.keyvalue=childtable.keyvalue ORDER BY fieldnameorder INTO CURSOR cursorname
Use things, not people. Love people, not things