>>I have a view that displays table results (viewgrid). In order to have access to all fields in the primary table (incident) when printing, I create a very simple select command:
>>
>>

>>select incident.* ;
>>    from viewgrid, incident ;
>>    where incident.inc_id = viewgrid.inc_id ;
>>    into cursor printjob
>>

>>
>>I would think that printjob would retain the fields in the order of viewgrid, but this is not happening. It seems to be in the natural order of incident.
>>
>>Is there something wrong with my select command? Should I be handling this differently?
>
>try
>

>from FORCE viewgrid, 
>

>option

Thanks all. In the meantime, I figured a way that seems to work. as follows

select incident.*, recno('viewgrid') as vrec ;
    from viewgrid, incident ;
    where incident.inc_id = viewgrid.inc_id ;
    order by vrec ;
    into cursor printjob