Hi Larry,

Yes I was setting the order in the child tables.

I also posted this question on Compuserve. A guy named
Gene Pasquini recognized the problem and posted this reply.
I pasted his code into my ShellRequeryMainViewAlias and it worked!
I don't know why it worked, but it did. Here is his reply:

Hi Paul, It's a VFP thing, VMP has nothing to do with it, but it manifests itself in the scenario you are talking about. Here's the pertinent code and notes from one of my FORM ShellRequeryMainViewAlias() which uses a related table in the grid... .... * Any one of these works to reset the * relation. Dont know what the deal is with * VFP, but Drew has the same problem. And * it also is same using all VFP base classes * use (.icMainViewAlias) in (.icMainViewAlias) * =seek(nMainId,"MyRelatedTable","MyTag") if between(recno(.icMainViewAlias),1,recCount(.icMainViewAlias)) goto recno(.icMainViewAlias) in (.icMainViewAlias) else go top in (.icMainViewAlias) endif ENDWITH * =seek(nRepId,"reps","repid") if between(recno(.icMainViewAlias),1,recCount(.icMainViewAlias)) goto recno(.icMainViewAlias) in (.icMainViewAlias) else go top in (.icMainViewAlias) endif ENDWITH

Thanks for your help Larry. By the way I'll see you at Maxteach again this
year!

- Paul