Bob,

You shouldn't open views created by Viewedit in the View Designer.

>Viewedit for VFP 6.0 seems to have to the same limitation with 'left joins' in remote views.
>
>Bsically it used UI and DBSETPROP command to create the views ending with the same problem. I guess in addition to a workaround in VFP 6.0, Version 8.0 is my best hope.
>
>Could you verify for me whether VFP 8.0 supports 'Left Join' between 2 remote views or more?
>
>That would be great help.