I have a database with 2 tables with a one to many relation. I have 2 grids one with the parent table and on with the child. With the relation set everything works correctly, but if I clear the relation with (SET RELATION TO) the parent grid works correctly but the child grid just stays with the records when the relation was cleared. If I turn the relation back on with (SET RELATION) everything works normal again. What is causing this behavior?

Gene Grant