>Can somebody help me with a problem I have with my grid behaviour. I have a start program which opens all my tables and sets relationships between them. When I run my form I set a filter to my first table and bind it to the grid. I have a method on the form which is called when the user changes records in the grid (AfterRowColChange event). Contained within this method will display the child records in another grid.
>
>The problem I have is when I move the record pointer in my first grid the record pointer shoots to the bottom of the grid. Therefore if I have 2 records in the first grid and then select the first record it wont let me as the last record is selected in the grid.
>
>Im confused!!!
It is not simple control two grids with a relation.
Remove the relation and uses SET KEY IN the child cursor into the gridchild.refresh
childgrid.refresh
SET KEY TO mastercursor.eRelation IN (this.recordsource)