I have an event list, to which I have added a Lookup column. I want to enforce relationship behavior between the two lists. (Specifically, I want to enforce cascading delete, but I encounter the same problem if I try Restrict Delete instead.)
When I try to do so, I get the following error:
[COMException (0x8107059f): <nativehr>0x8107059f</nativehr><nativestack></nativestack>This lookup field cannot enforce a relationship behavior because this list contains incompatible fields.]
Using the same lookup field on other lists, it works fine; I have only encountered this problem on an event list. How can I avoid this error, or at least figure out which field is incompatible?
View Complete Post