Ok, I may be doing some thing wrong here. I have 2 tables and one form that inserts to the tables. When i fill in the form the first record gets inserted in to boath tables. but when i try to insert a 2nd record i get a "Duplicate entry '0' for key 1." error

I am using a php page that i developed in Dreamweaver MX. Both of the keys are named the same and are an decimal.

ANy ideas?

could we see some code?
could be bad sql or bad php

Wen i submit through the web page i get this error:
uplicate entry '0' for key 1

now i noticed using CocaMySQL that the pkey default value for the PKey is 0. If i change it to 1 or i can insert a nother row, then i get the same error message. If i chance it to 2 it will work again but then stops when a nother row is added. I can not change this default field. if i try i dont get an error but it defailst back to 0
MySQL 16:38:03] SHOW INDEX FROM `Venders`
[MySQL 16:38:15] ALTER TABLE `Venders` CHANGE `id` `id` decimal(10,0) UNSIGNED NOT NULL DEFAULT ""
[MySQL 16:38:15] SHOW COLUMNS FROM `Venders`
[MySQL 16:38:15] SHOW INDEX FROM `Venders`

If i change it to Null i get:
[MySQL 16:39:39] ALTER TABLE `Venders` CHANGE `id` `id` decimal(10,0) NOT NULL DEFAULT NULL
[ERROR 16:39:39] Invalid default value for 'id'

Is there some Syntax that i am missing? i am fairly new to SQL in general.

Try :

Didn't work. any other ideas?

Can you post your code to insert a new row please ?

its probably how your tables are set up...
describe table;