I have 2 buffered tables that have a one-to-many relation on a maintenance form. There are several bound controls for editing the parent table fields; other controls are bound to the child. A grid is used to navigate between records of the child.

If going to the second record in the child and then edit the parent-bound field on the form, the child record pointer jumps to the first record. Note, that the parent field has nothing to do with the relation expression. I would certainly prefer the pointer to stay on the second record, or to move it back to the second record (if this is not avoidable in FoxPro).

I was trying with and without SET SKIP TO, by using and not using the grid's
ChildOrder, LinkMaster and RelationalExpr properties - it doesn't help.

There is more to it. While entering specific information in the child, I had to update the parent on the fly. So, I saved the work area, which is the parent; selected the child, saved its current record and did some calculation. Then, programmatically updated the field in the parent. While looking in debugger, I see that the child record stays where it was left at - not moving to the first one. When restoring the work area (selecting the parent), the child pointer jumps to the first record.

Still in control: moving it back with "GO nRecNo IN Child". But, the weird thing is that while I am in the described method, the pointer stays where it supposed to be. As quickly as the form gets the focus, the pointer is on the first record. -( I was trying to set a breakpoint on the change of the pointer in the child - it doesn't caching the change at all: I see the change in the Watch window but the message doesn't come up. I was trying to define events firing after moving the child record to the

right one and before I see it in the wrong place on the form. There were none (which is right - I was just calling a user defined method in a LostFocus).

I also had other bad situations with this freaking pointer but the application is heavily relying on the relation being in place - the rewriting for querying, filtering or another technique is not an option.

Please help.

Thank you.