I have a problem. I am storing projectid (varchar) as a field in this format :- DD-NNN where DD is the last two digits of the year and NNN is the next project number within that year (i.e. 09-500 is the 500th project in year 2009). The user has the ability to modify the automatically generated projectid.
Plus, there is 1 internal only project for year 2009 (09-000). This project should automatically be created at the start of a new year.
How can this be done? Please help me out !