Hello

Unfortunatelly, the View Designer will nest the joins. You can use 'Eview' (you'll find this app in Donwnloads section) or ViewEditor (Steve view designer made by Steve Sawyer (http://geeksandgurus.com/dl/viewedit2520.zip). Both very good and both allow to edit the SQL source.

Hope this helps


>I was following the example given by the view builder with three tables....it showed the joins and conditions seperately. Makes much sense the way both of you put it.....and, more importantly, it works the way you have it! <g>
>
>Thanks to you both for your quick responses.