Ask Your Question

Need to auto increment the ID number each time I add data from form

asked 2015-06-16 20:46:41 +0200

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).

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-16 22:19:05 +0200

jay Arr gravatar image

View your table which has the ID number with EDIT Select the ID row Click on the AUTOVALUE and set it to YES Save you table Now each time you add a new item the ID will auto increment.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-16 20:46:41 +0200

Seen: 3,239 times

Last updated: Jun 16 '15