HOW CAN I DO THE FOLLOWING CONSECUTIVE?
Hello, can someone please guide me how I can do a consecutive as follows
TRL-A-001
TRL-A-002
TRL-A-003 ...... TRL-A-999
As I get 999, the same first letters appear and only change A to B and so on until it reaches Z
TRL-B-001
TRL-B-001
TRL-B-002
TRL-B-003 ...... TRL-B-999
And since I have a form where there are many records when TRL-Z-999 arrives it appears
TRL-AA-001 when it ends up to TRL-AZ-999 follow TRL-BA-001
I don't know if something like that can be done?