Hello, I have been browsing on mysql manual <http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html> with not much of success.I am trying to put 2 foreign keys(from different external table) on my table, but if I put the 2nd one it fails.....here is my table CREATE TABLE pack_accomodation ( id int(16) NOT NULL auto_increment, pack_id int(16) NOT NULL , hotel_id int(16) NOT NULL , PRIMARY KEY (id), INDEX (pack_id), FOREIGN KEY (pack_id) REFERENCES pack(items_no) ON DELETE CASCADE ON UPDATE CASCADE, INDEX (hotel_id), FOREIGN KEY (hotel_id) REFERENCES hotel(items_no) )ENGINE=INNODB; I can get rid of the 2nd foreign key with programming, but I think it should be possible to have them both...I just I cant figure out why it fails with this error: ERROR 1005 (HY000): Can't create table './tabasam/pack_accomodation.frm' (errno: 150) For description of the error <http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html> Thanks guys, any help would really appreciate it. -- Extra details: OSS:Gentoo Linux-2.6.25-r8 profile:x86 Hardware:msi geforce 8600GT asus p5k-se location:/home/muhsin language(s):C/C++,VB,VHDL,bash Typo:40WPM url:http://mambo-tech.net
