I have been tasked to build a requirements gathering database. The user inputs information about project requirements, and this data eventually will feed a "System Requirements Document (SRD)." My customer's SRD template is broken down into sections, Section 4.4 is the "functional requirements." My customer would like each requirement in the database to be labeled according to this section scheme and he wants it to be done automatically. There are two levels that we are dealing with: 4.4.1....4.4.N and under these there are 4.4.1.1....4.4.1.N. I am at a loss as to how to design and code this automatic section numbering. What I am thinking is that for every requirement that goes into the database, the user first selects a level (say level 3 or level 4). If he selects level 3, then the system will know what is the next available section number within level 3, for example 4.4.2. If he selects level 4, then the database will produce a list of existing level 3's. The user will select the appropriate level 3, for example 4.4.2. Then the system will know what is the next available section number within level 4, but related to level 3 (4.4.2.1). Again, I am at a loss as to how to do this. Any suggestions would be greatly appreciated. 
