Hi all

I want to display a two level relationship (four tables) using 4 grids in a form - a parent table, the child table and 2 grandchild tables in grids. It seems the SET SKIP conditions for the relationship(s) are always refreshed, and the resulting child recordsets always redisplayed upon clicking on any cell in any row on my parent grid. I'd like to conditionally prevent the recordpointers in the child and grandchildren from moving if their parent(s) are just clicked upon - that is, when I don't change row in the parent.

Of course this behaviour is required when I move rows, but the entire grandchild recordsets usually change disconcertingly when I click inside the current row on the parent grid, because the child recordpointer moves to the top of its recordset, forcing the grandchildren recordsets which depend on it to change too. And I'd like to stop that if I'm still on the same row in the parent.

NODEFAULT in the grid.Refresh() doesn't help. I can detect row changes via the AfterRowColumnChange() event. From what I can see of the event sequence, the refresh of the relationships comes after the Before and AfterRowColumnChange() events too. However putting NODEFAULT in them doesn't doesnt seem to help either...

Maybe it can't be done - but I have to ask: Is it possible to stop this refresh of child grids?

TIA

Dick Hackett