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.....

It would be nice to know if it could be done...... but if it can't, it can't..

Thanks
Tommy

>You can do it programaticaly:
>
>

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

>
>Of course, in VFP8 it will be more than easy.