>>>You could use different cursors (could be the same structure): one as grid's recordosurce, another to accept data from the server; and you have a form's method where you refill the recordsource:
>>>
>>>set safety off
>>>zap in gridalias
>>>set safety on
>>>insert into gridalias select * from sqlalias
>>>thisform.mygrid.setfocus
>>>
>>
>>Yeah, but refreshing the Child cursor shouldn't effect the Parent in any way. My child grid actually works just fine with the current set-up...
>
>You should do it with both grids, i.e. don't override their recordsources, just use Zap and Insert.
Hi Ed
Let's give credit where it's due. As I understand things this was invented / discovered by Andy Kramek and is what is called the Safe Select.
IMO the grid should have an ability in itself to overcome this. I imagine the safe select cannot be as fast inserting a large number of rows as a native way for the grid to prevent this.