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?