Hi Susan,

If you create each of your conditions as separately named filters (ie, Pick seq containing P, Pick seq containing Q, Qty on Hand greater than zero, etc), you can use the Filter Toolbox to combine any combination of filters without having to get the formula syntax of AND/OR (or AND NOT / OR NOT). From the View menu, select Filter Toolbax. In your case, select all of the Pick Seq filters with an OR status to group them together, and the other filters with an AND status. This way, you can be responsible for creating just simple filters, and let the toolbox do the combining into more complex combinations.

If this is a common filter configuration for your inquiry, the New button in the Filter Toolbox will create a new filter for you based on the seletions, with the AND/OR syntax of all the sub-filters created for you.

The ShowMeHow video on GridView filters has a brief demonstration towards the end on using the Filter Toolbox. This feature was added in version 9.0D, so the WatchMe video for GridView 9.0D describes the Filter Toolbox in some more detail, at the very beginning of the video.