>>>How do I set the order of display for child records in a grid on a 1 to many form? Note: I am not using the data environment.
>>
>>In your relational key, just add the secondary key for the sort order.
>
>Michel,
>
>Could you be a little more clear? My tables are... The indexes on the fields have the same names as the fields themselves.
>
>DEMOGRPH (parent indexed on ID and also indexed on NAME)
> ID
> NAME
>
>LABTEST (child indexed on ID and also indexed on TESTNAME)
> ID
> TESTNAME
>
>I would like to display the child records ordered by testname.
>
>GRID PROPERTIES
>Child order: id
>Link master: demogrph
>Record Source: labtest
>RelationalExpr: id
You mentioned you wanted the child grid to be in a specific order.
If you have a child grid, this mean you have a parent field in it which is linked to the unique id of the parent table. By looking at your details, I would say that you can change the tag expression of id to be id+testname. The relation will still work and will be ordered. Howerver, you might want to do some translation in the expression in the case where id is numeric.