Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I cant add records to my table

I am using MySQL database

I created a new connection with LibreOffice base using database "inventory"

I created a new table called Assets with values like (assetID, mfr, model, serial) with assetID marked auto-increment and "Integer" datatype (showing a key on the row)

I saved Assets table

Opened assets table to enter data

virtually all options are greyed out cannot add any information at all.

Verified all the table info was indeed created via MySQL Workbench application.

Verified user has full access to database.

I googled and watched videos all night.

Everyone says its missing a key.

Mine is not, so what could be the problem?

Thanks for your help!