>>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
Barbara,
Believe it or not, I thought of that and actually tried this. I will try it again, but the first time, it did not work.
Thanks for the input; I'll let you know if I get it!
Mark
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only