>>>>>When a grid contains child records, is there a way to present them in an order different from the index upon which the relationship is based? Say the relationship is based on customerID but we want the child records to be presented in decending order by date.
>>The view will be
>>
>>select * from Child where CustomerID = ?m.CustomerID order by DateFld DESC
>>
>>For compound index it will be
>>
>>KeyField + str(2147483647 - IntField) && or just (-1)*IntegerField -- to sort in desc order
>
>Thanks Naomi. The compound works and that's good enough for me.

Ok, great.