If I deleted a customer data from a table, the customer ID is also delete and I want to rearrange the customer in order, that is I had customer from 1 - 20 and I deleted customer ID# 12, now the numbering is now from 1 - 11 and jump to 13, how can I change #13 to 12?
Reply from Richard Rost:
You can't change AutoNumbers. Once they're deleted, they're gone. You shouldn't rely on them for anything except making relationships between your tables.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
