Tommy,

The View designer for VFP7 and earlier is brain dead when it comes to complex views, so it can't create the view you are wanting.

What Esparta was telling you though is that you can use a CREATE SQL VIEW command to write your complex view into the DBC and then it'll be available for use.

You can open the view designer to grab the code from your existing view and then move that to a PRG that you will use to edit the view definition from now on.

>Yeah, but the old code I have here has a Remote View and I wanted to add some more conditions to it to cut back on the data being brought over from the Server.... the addition to it would be the .... AND ( B OR C ) part... and I am not sure how to get the View Designer to create the parenthesis.....

>
>>You can do it programaticaly:
>>
>>

>>CREATE SQL VIEW AS ;
>>    SELECT * FROM myData ;
>>       WHERE condition_A AND ....
>>
>>