I've just created a Database with a few tables, all with numeric primary keys:


I go in , browse a table, seelct option to add a record, and leave primary key as zero.

I then try to add another record...it wont let me saying 'Uniqueness of index XXXXXX violated.


I reckon the system is trying to assign a primary key of 0, but is there a way around this ?




Regards,
Gerard