Change Autonumber to Manual number

[PaulaB]

I have a database with 3 tables. I created 2 tables with the ID fields as the primary key and the data type autonumbers.

The 3rd table ID field is also the primary key, but the data type is number.

Data type - number - would work so much better for my other tables, but because of relationships and many forms and queries, I can't seem to change the data type. (There are also 3 "go-between" tables that are used to elimiate the problem of the many-to-many relationships between each table.)

Is there a simple way to change data type?

Thanks

 

[AlexMidd]

You have to make sure that any other tables that use the primary keys as foreign keys are of the same data type. The autonumber type uses the format "Long Integer". You should be able to change the fields to "Number" type as long as you keep the format as "Long Integer". Have fun! )

Alex Middleton

 

[Aivars]

Also see at thread181-106674 for updating of field.

Aivars