>Thanks again Nick, I'll play around with it

Jorge- the view designer's misbehavior in incorrectly arranging the JOIN clause in SQL is the reason I wrote eView. It is much like the view designer, but lets you edit more complex view that you have created by hand. you can get it here in the files section.