>I would rather use additional query to create a reporting cursor by joining the tables and filtering out records
>
Noted sir. Will redo my code, I just thought that execution is faster than retrieving a JOIN with repeating fields.
Thanks.
Dennis
>>I am using VFP 9.0 SP1. After retrieving them (already with an ORDER BY clause), they are SET RELATIONed TO another table which was also retrieved from MySQL. The code goes something like this:
>>
>>
>>SELECT StudentRecHDR
>>
>>SET RELATION TO StudentID INTO StudentRecDTLX
>>SET SKIP TO StudentRecDTLX
>>
>>IF llAllStudents
>> GO TOP
>> REPORT FORM ReportCard TO PRINTER PROMPT PREVIEW
>>ELSE
>> LOCATE FOR StudentID = lcStudentID
>> REPORT FORM ReportCard TO PRINTER PROMPT PREVIEW ;
>> WHILE StudentID = lcStudentID
>>ENDIF
>>
>>
>>The memo fields are in StudentRecHDR (the header table).
>>