What I want to do is create an incrementing id that resets to 1 every year with a prefix. The prefix is "10yy/", where 10 refers to the table and "yy" is the current year. For 2015 I want it to go:
1015/0001
1015/0002
etc.
In 2016 I want it to go:
1016/0001
1016/0002
etc.
The table is "RoadIM"...
