riahc3 1,467 posts since May 2008 Reputation Points: 45 [?] Q&As Helped to Solve: 17 [?] Skill Endorsements: 13 [?] •Team Colleague 0 2 Years Ago I habe table one with Col 1 (PK) Col 2 (NN) Col 3 (NN) Col 4 (NN) Col 5 (NN) Col 6 Col 7 Col 8 Then I create table two with Col 1 (PK) (AI) Col 2 Col 3 (FK) That col 3 from table two is col 1 from table one. I tried to make the FK relation in Workbench and it does not let me! I drop that table two....recreate from sratch and it says: ERROR 1005: Can't create table 'bd.table2' (errno: 121) SQL Statement: CREATE TABLE bd.table2 ( col1 INT NOT NULL AUTO_INCREMENT , col2 VARCHAR(70) NULL , col3 INT(11) NOT NULL , PRIMARY KEY (col1, col3) , INDEX col3_idx (col3 ASC) , CONSTRAINT col3 FOREIGN KEY (`col3` ) REFERENCES `bd`.`table1` (`col3` ) ON DELETE NO ACTION ON UPDATE NO ACTION) What is wrong?