>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.