>I have four grids on a form that associate with four tables--one parent and three child tables. The relations are set as follows:
>
>

>SELECT t_pi01
>SET RELATION TO T_PI01.prot_no+STR(T_PI01.prot_yr,2) INTO T_PI02 ADDITIVE
>SET RELATION TO T_PI01.prot_no+STR(T_PI01.prot_yr,2) INTO T_PI03 ADDITIVE
>SET RELATION TO T_PI01.prot_no+STR(T_PI01.prot_yr,2) INTO T_PI04 ADDITIVE
>

>
>Later in my program I want to turn off the relations and view all the records. So I do the following:
>
>

>SELECT t_pi01
>SET RELATION TO
>Thisform.Refresh()
>

>
>All the grids have a RecordSourceType set to "Alias"
>
>
>PROBLEM: All the child grids still show only the related records from the last relation. I cannot get the child grids to show all the records.
>
>What am I doing wrong?
>

Try moveing the record pointer in the child tables after severing the relation.

SELECT t_pi01
SET RELATION TO
GO TOP IN t_pi02
GO TOP IN t_pi03
GO TOP IN t_pi04
Thisform.Refresh()

HTH.