Hello!
I have a table which has a primary key which was originally set as a short text, but I need to set to an autonumber. I have updated it in the table as autonumber, however the main form does not update the data type to autonumber. I can't delete the field because it's required as a primary, and I can't even delete the table because it has relationships (that I can't delete, because the form isn't updating.)
Any Ideas?