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

Answer If cascade delete related fields option is enabled, Access automatically deletes related records in the child tables if the record from master table is deleted. For example if a student is removed then all the records related to the student must be deleted from fees table, marks table and so on. 

+ Report
Total Preview: 2151
What is the effect of enabling 'Cascade Delete Related Fields' when defining relationship?
Copyright © 2024. Powered by Intellect Software Ltd