>Hi ,
>
> I'm having trouble with a one-to-many grid. I can't access any record in the grid except the last one. All records are shown that relate to the record in the parent table, however if I try to change records using either the mouse or the arrow keys, it immediately changes back to the last record. Also no matter which table is currently selected, it changes to the parent table when I try to change records in the child. What 's going on? Can they make these grids any harder to work with?
>
>TIA
>Mike
Mike, Mark had some good ideas. However, you should also check your thisform.refresh (and any pageframe.refresh code) to see if anything there is re-setting the pointer between parent and child tables. For example, a SELCT PARENT might re-set the pointer to the first (or last, depending on indexes) child record. I had this problem once, and ended up with a custom refresh method.
HTH
Barbara