>>>Yes here's the code.
>>>
>>>SELECT &lcALLFIELDS FROM GLS!LM10, GLS!LM10TRS WHERE ;
>>> lm10.CDLRNMBR = lm10trs.CDLRNMBR ;
>>> INTO CURSOR LM10VUE ;
>>> UNION ;
>>> SELECT &lcNOTRSFIELDS FROM GLS!LM10 ;
>>> WHERE lm10.CDLRNMBR NOT IN ;
>>> ( SELECT lm10trs.CDLRNMBR FROM lm10trs )
>>>
>>
>>At least something get fixed. May I repeat the question: is record '215' ok in the cursor?
>
>Yes the record that contains the dealer number '215' is in the
>cursor.
I would do following: create report variable, assign it to cursor.balance (calculate nothing) and print it in group footer. Maybe this will work Ok?
Edward Pikman
Independent Consultant