Hi Team,
I want to have an autoinc (generated) # that allways starts withthe 4 digits of the year.
So, 202401, 202402, etc.
I also what it to change to 202502, 202502, etc when 2025 clicks over.
And so on.
Appreciate suggestions on how to manage this.

Regards & TIA,
Ian

Ian


Off the top of my head all I can come up with is using a beforepost trigger and an additional table holding the year and "autoinc" value.

If its for DBiWorkflow let me know table details and I'll try to  produce the trigger for you

More thinking is that a two column solution and resetting the start point for the autoinc each year could be made to work but would be clumsy and require locking everyone out of the database each year when the reset is done.

Roy Lambert

Hi Roy,
>>Off the top of my head all I can come up with is using a beforepost trigger and an additional table holding the year and "autoinc" value.

Yup, that was what I came up with, or similar, too.

Ian.