>Can anyone help me with this. I am trying to create a report (invoice) where the values come from the form that will be printed from. creating a list, is no problem. but say for example, i select only the third or forth customer. how can i print only that one record?
I (like many others) like to design my reports to run off of a single cursor with nothing more, and nothing less than what I need in my report. That means, if I wanted to print a report with all my records or jsut the currently selected one, I could create my cursor like this:
IF llPrintAll
SELECT * FROM mytable INTO CURSOR temp
ELSE
lnID = mytable.id
SELECT * FROM mytable WHERE id = lnID INTO CURSOR temp
ENDIF
And then just run the report like normal, with REPORT FORM.