Hi Jack.

If you are using the grid itself to manage the parent/child relationship, I believe you want to NOT have the relationship set up in the form dataenvironment. You DO want to have childorder, etc. properties properly defined. I would suggest setting the order property of the child cursor in the data environment to the default, which is none. Then set up the grid so that you are sure the parent-child link is operational. Then set the order property.

IOW, I wouldn't mess around with SET ORDER TO ... code at all.

HTH


>I set the cursor¡¦s Order property to ¡§No1¡¨ in a form¡¦s DE, and there is a grid displays records in the cursor. But when the form is running, the grid display nothing. So I open Trace and Debug window to check it. I find the cursor¡¦s order has been changed to "No2".
>
>I am sure that the LinkMaster and RecordSoruce of the grid are correct, ChildOrder and RelationalExpr are empty. Additional, I open a local-view base on the same table, and the view was SORT BY(not Index) ¡§No2¡¨.
>
>Even though I can SET ORDER TO TAG ¡§No1¡¨ in the form¡¦s Init to resolve this problem, but I really can¡¦t understand why.
>
>Thanks!
>
>Jack Lee