Can numbers be changed automatically
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