>>I think you're at about the edge of the designer limit on this view...you may have to proceed with code from here on...
>
>Does it seem to you that this is that big a stretch for the view designer? I can't believe that it chokes on this. A very simple view. The only real problem seems to be that there are two tables with the same field name. But both are resolved by table names.
>
>I started out with this in the view designer and wasted so much time scratching my head.
>
>I know, you cann't fight city hall both this one is a bug. It should be fixed.

I know, the designer stinks, I don't use it much any more except to get the code and view properties started on a new view, then I use GENDBC...one good clue of what stage to quit the designer is to look at the SQL there -- if it's all fouled up, forget it...I just took a look at yours, and it was indeed all fouled up...