Mark,

A view, is really just your SQL statement stored in the Database. Once you've created it you can pretty much use it like any other physical table. If you drag the view out of the Project Manager onto a form it will build the grid from the view contents. Or you can add a grid to a form and set the RowSource to TheViewName that's all there is to it.

If your table has a primary key, and every table should have one anyway, the view can be made updateable.

Parameterized views are very good at grabbing just the child records out of a table in a 1-to-many table relationship.

>Can you clarify to a newcomer exactly how to 'hook a grid to a view' ?