Somebody's probably dealt with this before so here goes:
I have a parent/child table setup with relation set in
dataenvironment. Tables are keyed with integers, child has unique
and parent record's key as foreign key. Code to add to child table
does INSERT into CHILD (ichildkey,iparentkey) values (lnNewKey,lnParentKey). I also tried with Append/Replace but still get following problem: If activecontrol is anything but the grid that displays the Child table, everything works fine. If activecontrol is the grid, everything works, but ONLY if I move off the newly added record in the grid. If activecontrol is the grid, activerow goes to the newly added record after the Insert code; if I just click on a control for the parent table a start navigating, the control moves through the child table and will no longer select the parent. Also,
I get the same problem whether Buffering is on or off.
I'm thinking of trying a workaround with a setfocus to a container before the Insert, but maybe someone knows a simpler route?
Thanks
Rod Poujade
McGill University,
Information Systems Resources
Montreal, Canada
Rod Poujade