The VFP view designer doesn't work very well with complex views. I've had great luck with eview, which you can get for free from the downloads section.

>Hi,
>
>I created a remote view (from tables in a local Access DB). Everything went fine whether I used the wizard or if I created the view manually myself.
>
>Once the view is created, I can browse it fine but every time I try to modify it (either by right-clicking on the view and choosing "Modify" or by calling "MODIFY VIEW" in the command window) I get an error:
>

>Command contains unrecognized phrase/keyword.
>

>I have no idea what I am doing wrong or what I need to set for this function to work.
>
>Thanks in advance for all your help.
>
>Stephane.