I am very new to this. I have created a database for keeping track of items sold to people at an auction. It has the date and an Id number as well as other needed things such as quantity and price and total price.
I need the ID number to auto increment so every entry is unique (it will never need to be started over).