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