Question:What is the effect of enabling 'Cascade Update Related Fields' when defining relationship? 

Answer If cascade update related fields option is enabled, Access automatically updates the key field value of related records in the child tables if the primary key field value from master table is updated. For example if a student roll number is changed then all the roll numbers of that student must be updated in fees table, marks table and so on. 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description