Specialized Autonumber

[albrad84]

I am creating a database for my company to register projects. And each project needs to have a unique Project ID number, which (due to the conformity of another software tool) must be 4 characters long. The first character is a specific letter based on the group the project is created by, followed by a 3 digit number. So, for example, one of the group code letters is C, so the first "C Project" would have the ID 'C001'.

I want my database to assign these automatically after selecting the group.

Any ideas?

 

[Meltdown]

Download the attachment in this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=75516

 

[albrad84]

I looked at the forum and the attachment and that helps, but the problem is that I want to have, for example, an ID of C001 as well as E001.

So what I am trying to do is have a table with the Group Names, the Code Letter for each group, and the number of projects added for each group. And then I want to have it, after choosing the group (in a form), look at that group's Code Letter and number of projects, then put them together to create the ID.

Unfortunately, I'm pretty new to access (though I do have a pretty decent programming background). I'm just not quite sure how to access the DB's tables and entries using VBA in order to do this