Case Numbers

[cruspy]

I have edited a case number in the database to be 1200. I want the next number to be 1201. It's using the number, however the database is posting 1211 instead of 1201. Where is the "ticker" for the case number kept? Is it looking up the max case number? If so, why is it picking out a different number than what is present in the table?

I must also add that when running a query: SELECT max(`case_number`) FROM `cases` , it returns the right number (1200).

[Angel]

You should use the following syntax to set the internal counter:

ALTER TABLE cases AUTO_INCREMENT = nnn;

nnn = the number you want to start at.

[cruspy]

That would work... THANKS!