No Sir, I am talking about the Access 2010 Beginner Level 9 first chapter Contact Table & Form. In this chapter after completing the form and when you start to input the data Contact ID automatically becomes 2. Please refer to the Contact Table & Form video Time Index start at 08:34 minutes. I would like to know why it becomes 2 instead of 1.
Reply from Richard Rost:
Ah. Good point. I'm glad you brought this up. There was probably a record that was inserted in there - either when I was making the table or first finished the form - that you didn't see because it was OFF CAMERA. I might have inserted a temp record and then deleted it to move forward. Or I might have made a mistake while recording and deleted it and re-recorded. In any case, that record is gone and that Autonumber will never be used again. The bottom line is that YOU should never have to worry what those Autonumbers are. They're meaningless for any HUMAN purposes. The only reason they matter is for forming RELATIONSHIPS between tables - which we cover in the next class: Access Expert Level 1.
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 9.