Primary Key with Alphanumeric ID

Is it possible to use an alphanumeric ID like this for exemple : MSG01 or TOOL025? If so, what would be the advantages? What would be a typical scenario for such a use? If not, why not?

Yes, but remember Base is not a database, it connects to databases. So the “yes” may depend on your type of database…

IMHO none, except human readability.

Pre-existing labels, for example in libraries could be directly used as ID.

Ok! So it’s a personal choice, anything is possible as long as you know what you’re doing and what database you’re using it with.

Thanks Wanderer!