1 2 Previous Next 15 Replies Latest reply on Sep 4, 2014 5:01 PM by user19752

    Is there a way to make sort order consistent?


      When I'm in Manage Database-->Fields and I sort by fieldname, I see all the fields that begin with an underscore on top, followed by fields that start with A, B, etc. But when I'm viewing records in a portal and I sort by one of the fields in the portal, the records in the portal are sorted as though underscores don't exist at all, e.g. A, _B, C.


      I'd like records sorted in a portal to be sorted the same way as fieldnames sorted in Manage Database. I know this can be done by calculating a seperate "sort by" field, but I'd like to avoid that for performance reasons. I've tried changing the sort langauge from English/Default to Unicode, but Unicode puts underscores at the bottom not the top (though at least that keeps them together!). Does anyone know the sort language that's used in Manage Database? Or does one of the myriad languages supported by FMP sort like English alpha but with underscores on top?

        1 2 Previous Next