Hi all,

How do I properly release and refresh the child table relation from the parent?

create cursor child (f1 c(1), f2 c(5))
index on f1 to child
insert into child values ('A','11111')
insert into child values ('A','22222')
insert into child values ('B','33333')
insert into child values ('B','44444')
browse last

create cursor _parent (f1 c(1))
insert into _parent values ('A')
insert into _parent values ('B')
set relation to f1 into child
browse last

Make sure that the Data Window is opened. View the child table and make sure that the relation from the _parent works. Leave both browse windows opened. Select _parents and from the Command Window remove the relation.

set relation off into child

Select the child table; do you notice if the 'filter' still exists? GO TOP; SET FILTER TO doesn't seem to work.