Profound Logic Forums

I have a subfile grid that shows the date using our corporate standard: ddMmmyy, e.g. 03Jan11, 23Apr11, etc. The subfile grid is initially loaded in date order, but clicking on the column heading sorts alphabetically, so Apr 3 comes before Jan 3. How can I display one field, but have another one control the sorting? If hidden fields can control the sort, how do I know which field in the column will be used?

--Bryan

Hidden fields can be used to control sorting. If you have more than one field in a column, the field that appears first in the Elements tab of the Designer will be used for sorting. You can change the order of the fields on the Elements tab by clicking the Move Up and Move Down arrows at the top.

Thanks. That worked well.

--Bryan