AnsweredAssumed Answered

Auto Enter Serial Number Reset

Question asked by petey on Dec 20, 2018
Latest reply on Dec 22, 2018 by philmodjunk



Besides a the script step "Set Next Serial Value," are there any other circumstances where an auto-entered serial number (in my case the primary key for the table), would reset?


I had this happen today and can't figure out why. I don't have a screenshot of it defaulted, but I do have one of what it was when I uploaded the database this morning, before daily use.




Here's the table view:




It looks like at one point it just stopped making the ID all together, then reset, then reset again. Here's more data on how the field is set up:


Type: Number

Options: Indexed, Auto-enter Serial, Unique, Allow Override, Validate During Data Entry


Any ideas?