Hi,
I'm creating a database for entering and retrieving information on in-house publications. I'm looking to create a custom number for each record entered into the database using a form. The number would be based on the selection of a section ID (TM, CR, SL, ...) which would be choosen from a combobox on the form. The number needs to follow this pattern, TM-2009-001, CR-2009-002, TM-2009-003, and so on with the number increasing by 1 for everytime a SectionID choosen. I also need the numbers to revert back to 1 when the year changes. This can be done either automatically or through a "reset" button. My knowledge of expressions and coding is very, very limited and i've been looking online for weeks trying to figure how to do this.Can anyone please help me?
I'm creating a database for entering and retrieving information on in-house publications. I'm looking to create a custom number for each record entered into the database using a form. The number would be based on the selection of a section ID (TM, CR, SL, ...) which would be choosen from a combobox on the form. The number needs to follow this pattern, TM-2009-001, CR-2009-002, TM-2009-003, and so on with the number increasing by 1 for everytime a SectionID choosen. I also need the numbers to revert back to 1 when the year changes. This can be done either automatically or through a "reset" button. My knowledge of expressions and coding is very, very limited and i've been looking online for weeks trying to figure how to do this.Can anyone please help me?