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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
isaac_cm Posted July 31, 2007 Author Share Posted July 31, 2007 many thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.