>>Look at outer-joined cursor. Does it really contains #215 record?
>
>Starting a new thread. I hate it when the thread gets too far
>to the right of the screen.
>
>Yes here's the code.
>
>SELECT &lcFIELDS FROM GLS!LM10, GLS!LM10TRS WHERE ;
> lm10.CDLRNMBR = lm10trs.CDLRNMBR ;
> INTO CURSOR LM10VUE ;
> UNION ;
> SELECT &lcFIELDS FROM GLS!LM10 ;
> WHERE lm10.CDLRNMBR NOT IN ;
> ( SELECT lm10trs.CDLRNMBR FROM lm10trs )
>
>
>Dan

I cannot believe that this UNION will work, it cannot be &lcFiELDS in both Selects. Do you select any fields from lm10trs?