Hello
I have the following two tables. Cascade delete works with no problem. It means when I delete the record in master table then all releated records are deleted in detail table too. But when I update the email in master table then the email in detail table are not updated and the relation from master to detail table is then lost. Am I doing a consideration mistake?
Table Master: users Primary Key: Id [INT], email [VARCHAR 50]
Table Detail: usersactions Primary Key: list_Id [TINYINT] AND Email [VARCHAR 50] (Composed KEY)
Relation: users
.email
=usersactions
.Email`
Thanks for any hint.
mpol_ch