>Unnest the joins. You will have to maintain this view programmatically and no longer use the view designer. Use EView from UT Downloads.

>SELECT CONFIGFILES.*, ;
>      PARAMETERS.CNAME, ;
>      PARAMETERS_A.CNAME, ;
>      PARAMETERS_B.CNAME, ;
>      PARAMETERS_C.CNAME ;
>   FROM GULFSTREAM!CONFIGFILES ;
>      LEFT JOIN GULFSTREAM!PARAMETERS ;
>            ON CONFIGFILES.IREMOTEPARAM1 = PARAMETERS.IPARAMID ;
>      LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_A ;
>            ON CONFIGFILES.IREMOTEPARAM2 = PARAMETERS_A.IPARAMID ;
>      LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_B ;
>            ON CONFIGFILES.IREMOTEPARAM3 = PARAMETERS_B.IPARAMID ;
>      LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_C ;
>            ON CONFIGFILES.IREMOTEPARAM4 = PARAMETERS_C.IPARAMID ;
>   WHERE CARTICLEID = ?VP_CARTICLEID

I use ViewEdit from Steve Sawyer. Has a few more features. Take a look at it at www.geeksandgurus.com. Funny thing is I pasted the code from the VFP view designer into my editor. I knew I couldn't save the view in VFP's view designer, but I used the designer to build the SQL. VFP built in all wrong!