Auto Increment Fields are automatically generated numeric values that increment by 1 for each new record. This field can be used to create a numeric ID for your records.

  1. The Name for your numeric field will help define what this value represents.
  2. Descriptions can be a good tool to keep track of further information to describe the field.
  3. The number in which your incrementation will be Starting At can be set to create values starting at a certain number of digits.

Below is a simple example of products and IDs where the new entry has an ID incremented by 1 from the last product added to the table.