AnsweredAssumed Answered

Sequential numbering skips

Question asked by stewart_1 on Jul 5, 2013
Latest reply on Jul 8, 2013 by stewart_1


Sequential numbering skips


     Filemaker Server 8. Accessed remotely using FM Pro 7. Some of us are also using FM Pro 11.

     We have a database that was created in the early 90's and currently has over 12,000 records.

     Each new record we create is automatically assigned a new sequential ID number. Several years ago we reset the ID numbering sequence to start from zero. The latest record ID number is 9381.

     Occassionaly when we create a new record the ID nunmber will skip a number. For example, our two most recent ID numbers are 9379 and 9381. 9380 was skipped by the data base when a new record was created. The happens occassionaly.

     I did not create the database but am trying to help out occassionaly.