2 Replies Latest reply on Sep 16, 2013 10:02 AM by fmpro_novice

    Help with Logic - Field Creation

    fmpro_novice

      Title

      Help with Logic - Field Creation

      Post

           I have a file where each record is a number, created randomly, but once all the data is entered, the numbers are sorted from low to high.  I need to be able to override the sort and no matter what number the record has, I want it to be sorted to the bottom of the list.

           In other words, once sorted, the numbers would be

           1
           2
           3
           4
           5
           6
           7

           But I need to be able to put a checkmark next to the record showing number 1, and if checked, 1 would then sort below 7, ending up like this

           2
           3
           4
           5
           6
           7
           1

           Any ideas?