>I've got a 1-to-many relationship on a form.
>
>The grid is the 'many'. I've got the two tables linked with a field called 'id'. This works fine. What I'd like though is to have the grid's records (rows) in descending order based on the field 'date' which is in the child table.
>
>I have created an index in the child based on descending date. When setting the ChildOrder property on the grid to 'date', my data disappear in the grid! It seems to only display my data in the grid if the ChildOrder is set to the matching field 'id' which also exists in the parent.
>
>Any ideas out there?
>
>Thanks,
>
>Mark
>mark@remarkable-systems.com
Mark, if (for any reason) you do not wish to use views as Josh suggests, add an index on ID + dtos(date) DESC. Use this index as your ChildOrder, and the data will show up correctly.
HTH
Barbara