Solved PK Autonumber... but with Text

[Da_Panda]

Hello,

Am creating a database, and about the PK. The standard, and very easy/comfortable way, is to use Autonumber (1, 2, 3,...). Then one could also just use Text, but one have to manually write it in.

Would then hear if its possible to a somewhat combination? And how?
eg. I'm thinking of a schema like: DOC001, DOC002, DOC003. Where the text body then stay the same, but then every time one make a new Record, the like with Autonumber, the number would then change to the next one in line...

 

[Minty]

You can format the auto number to display with a prefix.
In the format property simply add "DOC"0000

 

[Minty]

Unless its an accounting package and an uninterrupted sequence is an absolute requirement, I personally don't see an issue with a missing number if it's simply a unique reference.
Using a DMax approach works but is fraught with dangers with multiple users especially over slower network connections.