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:
Options: Indexed, Auto-enter Serial, Unique, Allow Override, Validate During Data Entry