Primary key autonumber with letters

[mimi_lupton]

Hi!
I am a new member of this forum and new to access.
I need to make a data base and I would to have my primary Key as an autonumber. I would like to use ID numbers that have already been assigned but they have letters in the beginning, they are GKAD0001 etc. so at the moment I just have them as text that wont allow duplicates, but really I would like them as and autonumber so when new data is added it automatically assigns the next number.
Is this possible?

Thankyou very much for your help.

 

[Dennisk]

you state that you have a set of IDs. are these in a spreadsheet?

The basic thinking behind Autonumbers is that they should not be exposed to the outside world ie do not let a user see an autonumber as they will use it on casenotes, invoices etc. An autonumber field should only be used internally as a PK in the one side of a one-to-many relationship andf as a FK in the many table.

If you have a set of numbers that are contigious that you wish to use then generating your own autonumber would be your best solution (plenty of examples here on the forum). I've not mentioned your query re: concatenating text as that is the least of your problems and is only trivial.

 

[The_Doc_Man]

mimi - search this forum using its own SEARCH option in the menu bar at the top of the page just over the "Post Reply" button over the first post of the thread. Look for topic "Autonumber" to see all sorts of useful - and non-useful - suggestions and comments on autonumbering. It is a very common topic.