nuAutonumber not working

[Ewald]

I have built a 'browse and edit' form to enter users into a database. Following the nuBuilderForte_UserGuide I can't make the nuAutonumber type working.
When creating the object (type set to input, input type set to nuautonumer, ID set to the primary key field of the database) I can't save it as long as the input type is set to autonumber.
If I set the input type to number, I can save it but then I can't enter a new record into the database.
What am I missing?

[kev1n]

You should not use an auto increment value as primary key.

The recommended table structure is described here:

https://wiki.nubuilder.net/nubuilderv3/ ... _Structure

Of course, you can add an additional field with type nuAutonumber.

[Ewald]

Thanks for your consideration.
My Problem will be that I want to use nuBuilder to access an already existing MySQL database. Thus the table structure is given and the primary key is defined as an autonumber value.
The table has the following structure: IDUser (prim., autonumber), FirstNameUser (Varchar), LastNameUser(Varchar). The 'browse and edit' form I built doesn't let me add new records.

[kev1n]

Don't create an object in nuBuilder for the primary key.
Then saving will work if there's a primary key with AUTO_INCREMENT in your table.

[Ewald]

Thanks, it works this way.