here is part of the create table
CREATE TABLE `assets` (
`assetID` int(11) NOT NULL auto_increment,
`barcode_number` varchar(20) NOT NULL default '',
`asset_code` varchar(20) NOT NULL default '',
`serial_number` varchar(100) NOT NULL default '',
`asset_user` varchar(100) NOT NULL default
Really sorry about this i just worked out if i dont select the foreign key
in an insert statement it will return this error i have to include this
into the query, i have also noticed i usually dont add auto inc fields in
the insert query but my departments table has a foriegn key join and is
return
Daniel Rossi <[EMAIL PROTECTED]> wrote:
> Hi there i am having another issue with key constraints now, i emptied the tables
> and made the foreign keys fine although now when i try and insert a row into the
> table i get this
>
> ERROR 1216: Cannot add or update a child row: a foreign key constr
