Hi Michael

The view designer isn't a good way to create complex views and will create invalid views as you describe unless you keep it simple.

You'd be better off creating your SQL view or query in code ensuring you get the correct syntax. There is a tool called eview in the files section here which would help this process.


Nick Mason