i would just like to ask how would be the code for this: yyyy-9999 in vb.net..
yyyy - for the current year
9999 - for the record number

like for instance, for the new record it will be 2008-0001... then for the next record it will be 2008-0002 and so on.. and then if the year ended like for example if the year turns to 2009, the outcome will be 2009-0001... the record will be back to the 0001 and the year will be automatically change to the current year.. that's how it is..

any suggestion how can i do that? i'm just a beginner in vb.net.. i want your help..thanks in advance.