I have two BO
FormatRates and RatesType
FormatRate has a peer single relationship to RatesType.
Rates Type has two attributes Sort and Name
I then have a query on FormatRate which is grouped on the shortcut of FormatRate.psRatesType.Name
Is there a way to have the grouping sort on the FormatRate.psRatesType.Sort shortcut but display the Name?
The names are as you might gather not meaningful in a alphabetic list and are not conveniently named that reversing the sort would have any impact.