>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