I'm trying to figure out how to do this with Access 2003 and I'm not sure at all how to go about it. I haven't done much with Access, but I do know Visual Basic.
I need to set it up so that I have auto-incrementing numbers based on a first field. So it would be something like this (including starting at 70000 instead of 0)::
Primary Secondary
AB 70000
AB 70001
AB 70002
DB 70000
DB 70001
DB 70002
RD 70000
RD 70001
RD 70002
I need to put in the records using a form. I need to get the next number in each set... so when I type AB into the first field, I need to get the next number in the second field for AB automatically. When I type RD into the first field, I need to get the next number in the second field for RD. And I need that auto-incrementing number to start at 70,000 for each of the two letter first fields.