5 Replies Latest reply on Oct 29, 2014 8:51 PM by KellyFisher

    Can numbers be changed automatically

    Pondwater

      Title

      Can numbers be changed automatically

      Post

      Is there a script that can be written the change the individual numbers in a field? I am contemplating a database that has a unique priority number for each entry. Say, one record has a priority number of 18 (there would never be more than 25 records), and suddenly it should be moved to #1. Is there any way to make it #1, change the prior #1 to 2 and so on down the numerical line? Or is #18 jumped to #5 could the first 4 stay the same and the others moved down to the point where #17 became the new #18.

       

      If this is possible it would be done on FileMaker 11 and accessed by both Mac and PC