>How about unbinding the child grids before you break the relation, break the relation, then re-bind the grid?
>
>
>ThisForm.grdChild1.RecordSource = ""
>ThisForm.grdChild2.RecordSource = ""
>SELECT t_pi01
>SET RELATION TO
>ThisForm.grdChild1.RecordSource = "alias1"
>ThisForm.grdChild2.RecordSource = "alias2"
>Thisform.Refresh()
>
>
>
>- Brian
>
>
That worked, too, and would be less i/o. Only thing left to manage is the record pointer in the child table after the relation is reset.
-Henry-