Brett,

The View Designer is fairly limited in the complexity of the views it can create. You can use the CREATE SQL VIEW command and code the view by hand.

>As I enter the filter conditions in my local view, I notice that the WHERE clause in the SQL command only shows the first condition + AND. I cannot save the 'corrupted' view, and reordering the conditions only causes the entire WHERE clause to disappear. I am using VFP 5.0a, patched with VSSP3.