Claude, it IS confusing - I remember trying to order a grid alphabetically and having the STRANGEST dataset appear because of this. As Cetin says, using a compound key will give you the results you want: ForeignKey + LastName + FirstName for example to list by name.
Barbara
>Thanks a lot everyone for your many advises.
>It`s finally working, well, in a certain way.
>
>Barbara,
>in other words, in the child grid properties we must set RelationalExpr and ChildOrder to the same key!
>In my case, I wanted to sort the child grid on a different tag and that gave me a blank grid.
>Humm, isn`t that strange? Using that tag for ChildOrder is not realy ordering the child table since the value of that field is the same for selected records!?
>(tell me if there`s something i miss)
>
>Cetin,
>your code bellow shows what I wanted to do. But I had to set ChildOrder = "parkeyfield" otherwise the child grid was blank. (i`ll verify my INDEX and TAGs again though)
>
>Claude
>
>
>>Now in your relation as Barbara stated, childorder seem to be wrongly set. :
use parenttable in 0
>>use childtable in 0 order tag reltag
>>select parenttable
>>set relation to parkeyfield into childtable
>>
>>* Correspond to properties of child grid
>>Childorder = "reltag"
>>Linkmaster = "parenttable"
>>RelationalExpression = "parkeyfield"
