install keys including a letter

[rgrstvr]

i would like to start keys for different suppliers with different letters. for example a company named ABC would have product keys starting with a and then a series of automatically installed numbers. that is the series of keys would be a1, a2, a3, etc. and then a company named Village woud have keys v1, v2, v3, etc. how can i do this without having to manually install thousands of keys?

[Xipooo]

Do you mean you want them autonumbered with a prefixed letter in front of them?

[orange]

How exactly do you define Keys? What is the purpose? I think you might want to research Database design and Normalization.
If you consider the Primary Key of a table as a tool for the Database Management System, you'll keep things simple. If you need other identifiers for yourself or users, then make a field to do so.
One caution, don't try to put too much significance in your concocted identifier. Use the one fact, one field approach and you will save a lot of time debugging and redesigning when a new "unexpected rule" pops up.

Good luck with your project.

[rgrstvr]

yes - that is exactly what I want to do.

[ItsMe]

Build a function that formulates the prefix and holds it in memory. Concatenate the variable to the autonumber field for display purposes.