2 Replies Latest reply on Apr 24, 2014 11:34 AM by philmodjunk

    Sorting Records



      Sorting Records


           I have a database that is held on a server which I have taken over from someone previously who has started it. Two of the numbers are not in ascending order- so I have sorted them and ticked keep records in sorted order but when I come out of the database it reverts to having the two records out of place. I have tried this on another database that is held on my MAC and this doesn't happen. 

           How can I keep the records sorted?

        • 1. Re: Sorting Records

               You could write a sort record script and have it trigger on layout entry for any of the layouts where you want them sorted.

          • 2. Re: Sorting Records

                 Sort orders specified from a client computer are specific to that one user and do not persist when the user closes the file. (Another user might choose to sort the records in a completely different order and you wouldn't want that sort to suddenly change what you see on your computer...)

                 You could use Perform Script On Server to sort these records and then the next time that you open the file as a client, you should see that sort order as the default sort order for that layout.

                 But please also note that the check box to keep records in sorted order means that the records will change position in the found set automatically if you edit a field specified in the current sort order in a way that requires that change to keep the records in order. It won't keep users or scripts from sorting the records in to different orders or even unsorting them. And any find that you perform will show the records in unsorted order unless you re-sort them after performing the find.