>Question...
>I want to use the View Designer to create a view that goes like this....
>SELECT * FROM mydata WHERE condition_A AND ( condition_B OR condition_C )
>Can the View Designer create a view using the parenthesis?? Or will I have to do this using SQL-Passthrough???
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.