• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Using FileMaker 5.5's New Fe... > Updating Auto-Entry Serial Numbers

Updating Auto-Entry Serial Numbers

When you delete a range of records in a database that uses an auto-enter serial number, you might like to be able to update the value of the next serial number so that the next record number will begin after the highest remaining serial number. This function was not available in previous versions of FileMaker. With the new SetNextSerialValue script step, FileMaker 5.5 provides a delightfully simple way to do this.

In this script, we'll use a field called ID Number that has the auto-enter serial number option. Since this script uses a Sort command, make sure that your serial number field is specified as a Number field. Text fields will not sort properly.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint