Rick,

Ah now the problem is clear. If the View designer can't create it correctly in the first place, how do you expect it to be able to edit it? *s*

Once you've created a complex view with code, that's how you have to maintain changes to it. Just alter the code and rerun it, that will replace the view.

>It does not give me an error. Instead, my view is created but the SQL statement is changed with brackets in inappropriate places.
>It looks like this when I see the SQL from view designer's 'Veiw SQL' menu item.