Hitendra,
A parameterized view will be a better long term solution, The view will give you the record subset and you can freely change the sort order of those records. There's an example on my website that will help get you started.
>I have a Grid, configured for Parent-Child, which displays data from the Child file in a specific order. It works fine and as I move to some other record in Parent table, the Grid refreshes accordingly.
>
>When I move to some other record in Parent table, in some case, I want to display the Child records in some different order. So I change the ChildOrder and RelationalExpr properties of the Grid. As soon as I refresh the Grid, it displays no child records. I tried resetting the LinkMaster property also and also resetting the RecordSource of the grid by
>
>Thisform.ChildGrid.RecordSource = Thisform.ChildGrid.RecordSource
>
>method to prevent recreating the grid agin.
>
>What is wrong here? Is there any fixed order in which the RelationalExpr, ChildOrder and LinkMaster properties must be changed?
>Any suggestions will be highly welcome.