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.