Appending auto increment numbers on a given root

[Thorben Grosser]

Hello Newsgroup,

I am building an archive database. For this matter every folder
receives a single id which looks like: x-x-xxx-yyyy (eg 1-2-568-4841).
The x-x-xxx- part is determined by the user input and describes the
location of the folder (building, rack...), the yyyy is a consecutive
number. Using the normal consecutive number would make no difference
between the racks. What I am looking for is that, for every x-xxx-xxx-
part there is a new series of consecutive numbers (1-2-562-0001,
2-2-874-0001, 2-2-400-0001... instead of 1-2-562-0001, 2-2-874-0002,
2-2-400-0003). Any clue how to do that?

thanks in advance
Thorben Grosser

 

[scubadiver]

Don't start a new thread for the same question.