Is there any disadvantage in using a text value as the PK in a table? I have always used AutoNumber values as the PK however I am converting data where the PK in the tables is alpha/numeric like AAA1234567. I thought about using an AutoNumber asnd just looking up the alpha value as needed but there are a number of related tables and I would need to modify them all.
I can create the next value by getting the "AAA" alpha part and just incrementing the 1234567 part so creating the key is not an issue.
Thoughts or suggestions?