AnsweredAssumed Answered

Auto Enter Serial Number Reset

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

Hello!

 

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.

 

Field.png

 

Here's the table view:

 

Error.png

 

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?


Cheers,Pete

Outcomes