>>Thanks for the info Jim. I will try the other method you suggested.
>>As far as the parameterized view would that be something I put in the
>>parent grid change record event so I reselect the child table each time?
>>
>>thanks Gary
>Gary,
>
>You would need to track the current record number in the BeforeRowColChange event, perhaps by sotring it to a customer property of your parent grid, then in the AfterRowColChange event you would cehck to see if you are on a new record, if you are you would;
>
> lcParentId = ParentAlias.ParentId
> Requery("ChildViewAlias")
> THISFORM.ChildGrid.Refresh()

I'll try this Jim. It dows look simple.

Gary