Wanted: Unique Records

In the previous lesson we created a new customer named Alpha Beta. This customer had ID number 1. During our practice, we deleted the customer named Alpha Beta. O.o

 

1. Try it: Enter the Customer, Again

tblCustomers is open in Datasheet View.

Create a new record. Click on (New).
Enter the First Name: Alpha.
Enter the Last Name: Beta.
Enter Address1: 123 Practice Street.
Enter the City: MyTown
Enter the State: MI
Enter the Zip: 48103
Enter the Home Phone: 8102313211

What Do You See?
The new record has ID 5.

It did not get ID 1, again.

 

Why?

Home ->Views->View->Datasheet View