Jerry,

It's just a limitation of the view designer. You don't have any control over the () when combining AND and OR to get the precedence you want. Start with the view designer, then take it's code and fix it. I have a .prg with the views that can't be done in the VD for each app.

>I had created a view using the view designer but couldn't persuade
> it to form the syntax of the SQL statement the way I wanted it to be.
> In order to solve this parsing problem in the view designer I had
> to use CREATE VIEW command in the command window: