.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Articles >> SharePoint >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Cascaded Delete in SharePoint

Posted By:Jean Paul       Posted Date: November 30, 2014    Points: 200    Category: SharePoint    URL: http://www.dotnetspark.com  

In this article we can explore Cascade Delete option in SharePoint

In this article we can explore Cascade Delete option.

Scenario: We have two lists with connected column

Customer list is connected with Project list, where Customer Name is a column of lookup.


Please specify the lookup list & column name.


The Data Integrity can be maintained through:

  • On updating Customers, the change should reflect in Projects
  • On deleting Customers, if associated projects exists, delete should be PREVENTED
  • Or, on deleting customers, the associated projects should also be deleted (CASCADE)


Now try adding a new customer (Contact Template), please remember to set the Last Name as well.


Now try adding a new Project (Custom List Template) with lookup column & relationship checked.


Once you have a customer & project, try deleting the customer item.


You should receive the following error.


This OOTB feature ensures Data Integrity.


Advanced Scenario

This may not be the case always; some lists will lack OOBT relationship option.  We can use custom event handlers to block the deletion option, in such cases.

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend