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 ADDITIVELater 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"