changing autonumber field to number datatype

Question

Is there any way to change the autonumber field to a number datatype, when the field is used a primary key and linked to other tables?

Answer 1

You will have to delete the relationship(s) between the table and any foreign key columns on other tables first. Change the data type and then recreate the relationship(s).