Auto Increment Letters and Numbers

[Tyndie]

Hi,

Is there anyway possible of having a primary key, where first a set of two numbers increment to 99, and then a letter is incremented like so:

AA00
AA01
.....
AA99
AB00

If this is possible, does anyone have any tips on how to do this please?

 

[gemma-the-husky]

you are probably best having an autonumber key distinct from this reference.

store the last value of the autoincrementing key in a table. when you need to read a reference, lock the table, and write code to read the next ref, and set the common table accordingly.

if you read this reference early, and then cancel the new edit, you will lose the reference so leave the read until you are committing the update (only becomes a problem if users need to see the reference early on. Try searching for nextautonumber here (not access help)