6 Replies Latest reply on Jul 25, 2016 10:39 AM by dbarthold

    Undo a field sort?

    dbarthold

      In sorting a field on my database, I did not realize the values in this field would disassociate from all the related values in other fields.  Any way reverse a sort, and how to you carry all  the values in all the fields for all records with you when you sort one field?

        • 1. Re: Undo a field sort?
          beverly

          Your question is a little cryptic. Can you explain more?

           

          Sorting can be UnSorted, but not UnDone.

          Sorting by one (or more) fields changes the order of the RECORDS (as a whole).

           

          If the 'related values' are based on (or not based on) a sort order, then perhaps you need a design change?

           

          Can you post any screenshots with more details?

          bevelry

          1 of 1 people found this helpful
          • 2. Re: Undo a field sort?
            dbarthold

            I'm more used to the excel terminology, so let me just say I sorted the values in one column and found that all the other columns remained as they were.

            • 3. Re: Undo a field sort?
              dbarthold

              And even when I deleted the values under that field and re-imported them from the source document, they still "sorted" in a way that was identical to the deleted records, so the sort command seems to be there still.  Just don't know how to reverse it.  Appreciate any help you can offer.

              • 4. Re: Undo a field sort?
                beverly

                That is NOT possible in the database. But it is possible in Excel (spreadsheet) unless you tell it to keep the row intact.

                 

                for example (sorted by column 2 or creation order):

                a     1     zyx     2

                c     3     wvu     1

                b     4     abc     5

                 

                sort by column 1:

                a     1     zyx     2

                b     4     abc     5

                c     3     wvu     1

                 

                sort by column 3:

                b     4     abc     5

                c     3     wvu     1

                a     1     zyx     2

                 

                sort by column 4:

                c     3     wvu     1

                a     1     zyx     2

                b     4     abc     5

                 

                Do you see how the ENTIRE ROW stays together?

                 

                What are your other columns based upon that they would have "remained as they were"? Are they calculations that are based off the POSITION of the row in the found set, such that row 1 is row 1 even if a , b or c "row" is in that position?

                 

                please post your field definitions and screen shots!

                beverly

                1 of 1 people found this helpful
                • 5. Re: Undo a field sort?
                  beverly

                  look at the SORT dialog. There is a setting to "keep sorted"

                  keepsorted.jpg

                   

                  is that what you have? You can also, Uncheck and click UNSORT button.

                  beverly

                  2 of 2 people found this helpful
                  • 6. Re: Undo a field sort?
                    dbarthold

                    The computer I have the data base on is offline, so it's not easy to provide a screen shot.  There's nothing exotic about the other field definitions.  The sort command only sorted the values in the columns I selected and left all the other values as they stood on the table.  "Keep records in sorted order" was checked in the dialog box.

                     

                    I'm going to bow out of this as try to muddle through on my own, but I appreciate your efforts to help.