Re: ERROR 1005 <errno: 150>

[Angel]

I am having the same error with a different table - did you figure yours out yet?

here's my table which seems easier - but - is still enough for me to commit suicide over..

CREATE TABLE `Coaches` (`CoachID` INT(2) NOT NULL AUTO_INCREMENT,
`CoachLName` varchar(40) NOT NULL default '',
`CoachFName` varchar(25) NOT NULL default '',
`DOB` date NOT NULL default '00-00-00',
`CarWins` int(3) NOT NULL default '0',
`CarLoss` int(3) NOT NULL default '0',
PRIMARY KEY (`CoachID`),
UNIQUE KEY `CoachID` (`CoachID`),
KEY `TeamID` (`CoachID`),
CONSTRAINT `CoachID` FOREIGN KEY (`CoachID`) REFERENCES `team` (`TeamID`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Any ideas? I thought I would jump in here in case you got some ideas/replies before I posted my own thread...

Thanks
Angel. (my last programming class ever UGH!!)