Skip to main content
edited tags
Link
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63
Tweeted twitter.com/StackSharePoint/status/1117804914040766466
Source Link
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

SharePoint 2013: Error while creating lookup column

We are using SharePoint 2013.

We have two lists in our site: one custom list and one calendar list.

We are trying to add lookup column in Calendar list and referencing the custom list.

Adding lookup works fine. But when we tried to Enforce relationship behavior to Cascade delete, it throws an error.

Error we are getting:

This lookup field cannot enforce a relationship behavior because this list contains incompatible fields.

The Goal is to delete all the calendar items which has lookup set from custom list when the corresponding item from custom list is deleted.