Sharepoint - SharePoint 2013: Error while creating lookup column
This is a Known behavior of Calendar list (Event Content Type) in SharePoint.
Work around:
I followed below steps to achieve the cascade delete on Event Content type:
- I created one custom list instead of Calendar list.
- Added lookup column from Parent/Provider custom list and set Enforce relationship behavior to Cascade delete.
- Added Event Content type in lookup consumer list (Newly created custom list).
- Added newly created lookup column in Event Content type (Add from list columns).
- Verified deleting items from Parent/Provider list and it automatically deletes event items from consumer list.
Note:
Set Enforce relationship behavior to Cascade delete on lookup column before adding Event content type to consumer list.