serial number query
Basic newbie question. I've set Serial number/on creation and entered a next value of Dec100.
User enters a new record. The serial number automatically inserts Dec100. Fine.
User enters a second record, the serial number automatically inserts Dec101, which the user changes to Jan1.
User enters a third record, the program automatically inserts Dec102. How do I get the program to prompt Jan 2 instead.
At the moment I have to access the database definition and change the number there, but thats not something and end user can do.