>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.
Problem is not the order of them, old realtion is alive. Setting relationalExpr doesn't automatically set it.
.Recordsource = ''
select parent
set relation off into child
.ChildOrder = 'NewOrder'
.RelationalExpr = 'NewRelation'
.Recordsource = 'child'
Cetin