Generate sequential id after form submission

[Mikolaj_Wasniew]

Hello,
I have an “id” column in my table. How can I generate sequential “id” after submitting the form?

|id|First name|Last name|
|1|John|Doe|
|2|Mary|Jane|
|3|Raplh|Smith|

I.e. after creating a new record “Tony Jones”, id=4 should be added automatically.

[ScottWorld · Accepted solution]

Change the ID field to an “autonumber” type.