One option - and the best for speed and flexibility - would be for the child grid to be based on a parameterized view. A parameterized view will show only the records that fulfil a certain condition. The condition, of course, would be coincidence with the value of a parent record.

>Hi,
>
>Is there an "easy" way to set up a one to many form, where the grid has a local view as its source, and the main form is based on a parent table? I've tried this with the grid builder, but it won't allow me to set a related index for the child table (which is included in the local view in this case). Although, I realize that a view is a form of a query, and not really an actual child table (which is probably the problem).
>
>I have included the local view in the data environment of the form, but the grid builder's "related index in child table" combo box is empty with no selection options. I'm able to set the key field in the parent table, but that is all.
>
>Any help on this would be appreciated.
>
>Dave