>they are all real tables. Here's the actual coding:
>
>cSelectStat = "select "+lcfields +;
> " FROM dride "+;
> " left Join dtpprates On dtpprates.ratespk = dride.ratedtppfk "+;
> " left Join dtpp On dtpp.tpppk = dtpprates.tppfk "+;
> " left Join CRSCHOSEN On CRSCHOSEN.tpppk = dtpp.tpppk "+;
>" left Join dpass On dpass.passpk = dride.passfk "+;
>" left Join CLIENT On CLIENT.personid = dpass.personidfk "+;
>" INTO Cursor crsbilling"
>
>&cSelectStat
>
>Ok, will try this your advice. Thanks.


Also since it's a cursor what you are creating, it will not be called "crsbilling" as a physical file, use DBF() to get the real name and path.

Luis