Sergey,

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).

Dennis

>Dennis,
>
>Are you doing anything with records between retrieving them and printing report?
>What VFP version are you using?
>
>>
>>Actually, every time I test it, the records are always correct.
>>
>>Quite a few times though, during the actual run of the report card generation, the teachers have shown me a 'jumbling' of two TEACHER REMARKS memo fields. ( Student A has in his printout the Teacher Remarks of Student B and vice versa ).
>>
>>Worth noting though is that it happens to the FIRST and SECOND students that are printed out. A section usually has around 40-50 student records.
>>
>>These memo fields are coming MySQL table fields of the TEXT data type.
>>
>>