Ok, so i have a database, with very many tables, forms and queries.
In the initial database design, i used the id auto generated, which auto increments, as the primary key, and then created all the forms and queries, and these all work fine.
The needs have changed, and now i want to change the primary key in one of the tables, from the auto id, to something else, still unique though.
Am not quite sure, what the effect of this will be on the forms and queries.
Is it ok for me to change the primary key?