Re: foreign key problem!!

[scuba]

He Jan, thanks for helping - here an example code pointing out my problem. Insert identical data into both tables:

ID | NAME
1 | Karen
2 | John
3 | Maria
4 | Kevin

Now change John in parent into Maria. Child will change into Maria too - so far so good. Now go back to parent and change Maria on id 2 into Thomas. Child now changes both Marias into Thomas instead of just the one on id 2. I really need to find a solution on that - if there is one. Thanks for any help in advance!!!

CREATE TABLE parent
(
id INT NOT NULL,
name VARCHAR(10) NULL,
PRIMARY KEY (id),
INDEX name_ind (name)
)
TYPE=INNODB


CREATE TABLE child
(
id INT NOT NULL,
name VARCHAR(10) NULL,
INDEX id_index (id),
INDEX name_index (name),
FOREIGN KEY (id) REFERENCES parent(id),
FOREIGN KEY (name) REFERENCES parent(name)
ON DELETE CASCADE
ON UPDATE CASCADE
)
TYPE=INNODB;