I wanted to create a 1 to many relation, and use the properties of the child grid.

My primary database, called be, has an index on a field called bcnudos

My child database, called BCL, has a index on a field called bcnudos+str(bclig,3,0)
with T1 as tag name. bclig is the line number.

The properpties I gave to the grid were

Childorder = T1
Linkmaster = BE
Recordsource = BCL
recordsourcetype = 1
relationalexpr = be.bcnudos

With this informations the grid did not show the lines. To work correctly i had to create an index on the child database on bcnudos, but in this case the lines where not represented in an ascending order, but in the natural order.

How can i do to have the lines in an ascending order, THANKS