1 Reply Latest reply on Mar 6, 2017 12:36 PM by Malcolm

    Keep Database Sorted

    hollface

      We have a database of contacts that I would like to stay sorted in alphabetical order. I understand that the Sort Records button is only to sort during the time you have the Database open, and each time it is re-opened, it goes back to the order in which the records were created.

       

      Is there a way to instruct the database via script, upon opening, to sort in alphabetical order by Last Name field?

        • 1. Re: Keep Database Sorted
          Malcolm

          yes. There is.

           

          Create a script that does the sorting then go to File->File Options... -> Script Triggers. Select "OnFirstWindowOpen"and then use the picker to choose your script.

           

          Don't forget that any find will return records in unsorted order, that includes go to related record, so you have to sort the records quite a bit.

           

          Malcolm