We have our ticket numbering set to auto increment, we started with a 5

digit ticket number to a 6 digit to now a 7 digit in a really short

time. (10 thousand tickets though it appears as though 1 million)

 

This is what happens:

First ticket- 10001, 10002, and so on until it reaches 10999

then switches to 101000, instead of going to 11000.  It just adds

another place value.

 

Now it went from 109999 to 1010000

 

 

Any idea as to why it may be doing this?  In just 4 months we have

gone from a 5 digit number to a 7.  We really don’t want to have 11

digit ticket number by the end of the year mark.