>>>>BTW, why you're passing form's DataSessionID to the method? I hope you don't do anything with it...
>>>>
>>>>>>Hi Beth,
>>>>>>
>>>>>>You're doing something too complex here. Why do you need to reset recordsource for the grid? Also you don't have to explicitly call DODEFAULT(), you may comment it out, nothing will change.
>>>>>
>>>>>I am resetting the recordsource for the 2nd grid. I put the DODEFAULT() in there because I was trying to get the grid ARCC to set the record pointer to the correct record, so that my contactid would be the correct one and let the other code get the correct records. At the moment, it stays on the first record, so the second grid never really gets changed.
>>>>>Beth
>>>
>>>I pass the form's DataSessionID to the procedure to be sure when in procedure that I am in the correct datasession to work with the cursors. In other words:
>>>

>>>set datasession to pnDatasession
>>>

>>>is in the settable procedure.
>>
>>This is very dangerous stuff. Unless you have some code that changes DS in form's lifetime you better not do anything with DS.
>
>I am going from a private datasession form to a prg. I have seen this have problems before, so I, when I first made this form and code - way back when - so that was passed in to be sure the code was looking at the correct datasession and tables.
>
>Now, I am trying to do the simple three lines, but I HATE insert, because it wants you to list every field in the insert and select. append is better, because I do not have to list the fields, just *.

You don't have to write every field in insert statement.

You only need

insert into myTable select here list the fields to match the structure of your cursor from myTable where myCondition