Thanks for your reply Devon.I'm actually looking for exactly what was described in the original post in this thread.  To have tickets numbered 2024_001 and on, then in January switch to 2025_001.  For now I'm using the autonumber field until I'm gran...

Hi Atusr,My organization has disabled scripts, so your solution would be a great help to me.  Can you go into a little more detail on your process?  If I'm reading your post correctly, I would want a 2nd table with a column that contains incremental ...