Custome Sequential Number

[cimcore_dl]

I am building a job log and I need the "Job number" to be sequential and I need to start the database numbering at "70600" which is the job number we will use for using this log and throwing out the old way of doing it. How do I get this to wok? Thanks.

[peebee]

Already built into Appgini.

Set the "Job number" field (lets say it is named "job_number") to be "Auto Increment" in Appgini, then set the initial value for that field in the database to 70600

ALTER TABLE job_number AUTO_INCREMENT=70600;

Here's a reference for altering the value: http://www.mysqltutorial.org/mysql-reset-auto-increment