>>>>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.
Please. Most likely, it was 'invented' by multitude of independent programmers. Personally, I can assure you in the strongest terms, that I was able to make this code myself.
Edward Pikman
Independent Consultant