Ed,
>I found that any view going to grid can be simplified in code (no joins) and accomodated in grid (customized column.controlsource).
I create views, drag them onto a form and the grid pretty much works exactly as I want. Usually all I ever do is remove the key field columns and change a few column widths. If I need to reuse the same view grid in more than one place I save it as a class.