isaac_cm Posted July 31, 2007 Share Posted July 31, 2007 Hello, I have 3 table Main_category, sub_category, products main_category and sub_category is a master detail relation with cascade rule products table is related to both previous tables And I set two foreign keys one for main_category (cascade) the second for sub_category (cascade) , so is right or I have to make 1 foreign key to the sub_category ? and if modification happened to main_category like changing id number is this modification will be reflected in sub_category and products tables as well ? plz advice thanks Link to comment https://forums.phpfreaks.com/topic/62675-solved-question-about-cascade-rule/ Share on other sites More sharing options...
fenway Posted July 31, 2007 Share Posted July 31, 2007 If you have a FK constraint, it will be updated according to how you specify on delete and on update rules. Link to comment https://forums.phpfreaks.com/topic/62675-solved-question-about-cascade-rule/#findComment-312097 Share on other sites More sharing options...
isaac_cm Posted July 31, 2007 Author Share Posted July 31, 2007 many thanks Link to comment https://forums.phpfreaks.com/topic/62675-solved-question-about-cascade-rule/#findComment-312177 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.