Create a field that automatically increments numbers

See Also

1. Open the table in Design View

2. Select the Fields tab

3. To insert a field within the table, click in the row below where you want to add the field, and then select Insert from the Field menu, or right-click on the field and select Insert
To add a field at the end of the table, select Add from the Field menu, or right-click in the fields grid and select Add

4. In the Name column enter the name of the field

5. In the Type column click the arrow and select TINYINT, SMALLINT, MEDIUMINT, INT, INTEGER or BIGINT as the field type

6. In the field's property box, select Auto Increment

7. Select the Index tab

8. In the Index Name column, enter the name for the index

9. Move over to the Field Name grid, click on the arrow and select the auto increment field you just inserted

Note: There can only be one Auto Increment field in a table and it must be defined as an index (key).