[Venerable Bede]

Heres what I have for the 2 tables :

notice how there are multiple foreign keys referenced. This must be where I have repeatedly tried to create the relaionship, however when I open up “Manage Relationships” none show up. How can I correct this ?

CREATE TABLE `titles` (

`pub_id` int(11) default NULL, `title_id` int(11) NOT NULL auto_increment, `title_description` varchar(100) default NULL, PRIMARY KEY (`title_id`),

KEY `pub_id` (`pub_id`), FOREIGN KEY (`pub_id`) REFERENCES `publishers` (`pub_id`), FOREIGN KEY (`pub_id`) REFERENCES `publishers` (`pub_id`) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (`pub_id`) REFERENCES `publishers` (`pub_id`), FOREIGN KEY (`pub_id`) REFERENCES `publishers` (`pub_id`) TYPE=InnoDB CHARSET=latin1 ROW_FORMAT=DYNAMIC

CREATE TABLE `publishers` ( `pub_id` int(11) NOT NULL auto_increment, `pub_name` varchar(100) default NULL, PRIMARY KEY (`pub_id`) TYPE=InnoDB CHARSET=latin1 ROW_FORMAT=DYNAMIC

[Venerable Bede]

I have not used any sql. I have used the sqlyog front end.

This is driving me nuts.

[Author]

Posts