Just one piece of advice with this.... I used to do something similar. We have project numbers for this year start at 20001, 20002, etc.
Thought that was important. Someone on the forum said why, there really is no good reason. My team wanted it etc. I made it simple went with an auto incrementing number and it really was no big deal and has worked out great. Any argument wasnt necessary because Quick Base tracks when you create the record so I always know what year the project originated.
So just think about if you do actually need it before doing it.
------------------------------
Ivan Weiss
------------------------------