I am creating a record using a form. My table has a primary key field called “id” which has auto_increment.
Jet Admin still requires me to set a value for the “id” field. Since this will be the MAX(id)+1 I don’t have that value at hand so I’d rather leave this to the RDBMS to handle.
I have tried setting that value to NULL, however it throws a “server error”. In the background the record is created yet it is a bad user experience and stops the workflow.
The field configuration:
±-----------±-------------±-----±----±------------------±----------------------------+
| Field | Type | Null | Key | Default | Extra |
±-----------±-------------±-----±----±------------------±----------------------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
Any ideas?