Mark,
Your relationship depends on the child table having its order set to the field that's the foreign key for the relationship. If you want to be able to change the grid order you may want to use a view for the child records. Create a view and parameterize it on the foreign key. Each time the record pointer changes in the parent table you'll need to REQUERY() the view and refresh the grid.
>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