auto incremental numbers
I've created a database following the tutorial setting the first field a ID and makeing that auto incremental and the primary key.
I now want another field to be called product_ref to be auto incremetal and start at 5000
so I set the field name
set it to integar set it to auto increment
set the default to 5000
However when I select save I get the error
"incorrect definition there can only be one auto colum and it must be defined as a key"
where have I gone wrong