In Access/SQL tables how advisable is it to use text data type as a primary key.
I am building a database specifically for manufacturing where Part numbers and Customer Codes
, both text fields, need to be stored as the primary key. Is this advisable?
At the moment the tables are in Access but will in future be moved to a cloud SQL database.