>The view is created but when I USE it only returns about 1/4 of the rows I expect. If I just issue the sql select without the view it works fine.
Does the query return a large amount of data? Maybe VFP is still fetching data in the backgroud/

>Also if I try to modify the wholsale view I get the error SQL: "Cannot Locate Table"
>
>I've tried to create the view with the designer but it has problems with more than 1 join.
>
>I am new at using outer joins, maybe there is something wrong with my syntax.

Is't not your syntax. The view designer is pretty primitive. For more complex views, like yours, I always handle them without the designer.

-Mike