>Here is the setting:
>
>Table1 is related into Table2.
>Table2 is related into several child tables.
>Forms' parent grid uses Table2 as recordsource.
>
>If I programmatically change the recordsource of the parent grid to Table1, the childgrids go dead (they no longer updates their contents as I move from record to record in the parent grid). All relations are intact after doing this, so why doesn't the childgrids follow the childtables any more?
Vidar,
What is teh currently selecvted work area when you are navigating your parent grid? If it is not the parent table, then all relations from that table are suspended.
You may have better luck dumping the relationships and using the child grids' LinkMaster, RelationalExpr, and ChildOrder properties to make the relations.