Want numbers to be in order

[chillin]

I designed a database for our small company ten years ago. In my order table I have the Order No. field as the primary key and it is a text data type. Orders started at 1001 and we have just hit order no 10000. Instead of falling after 9999, order no 10000 is back at the top before 1001. I thought changing the field type to number would allow it to continue in a consecutive order, but it won't allow me to change it, it says I must remove the relationships with other tables.



I don't know enough about Access to do that. Can anyone help?

[ItsMe]

I would probably create a copy and remove the relationship. Then see if I can get the data type to change over to Long Integer.

Check to see if all is well. Afterwards, it would probably be easiest to repeat the process in the production DB. Although, best practice is to make changes in a copy and import the changes. The difference here is Relationships are typically included in the import process and you will have to rebuild the relationship anyway, even if you opted to not import Relationships.

[chillin]

Thank you. Took me awhile, but I was finally able to figure it out and fixed it!