I have field on the contact record called "Spouse Lookup". This is a lookup field to the contact table, so N(Contact):1(Contact).
I can populate the field just fine on one record - Spouse A has Spouse B in the Spouse Lookup field - but when I try to add the other spouse - Spouse B has Spouse A in the Spouse Lookup field - I get the following error:
"Cannot associate records
This lookup creates a parental relationship between records and you attempted to link this record to itself. This is not allowed because it would create a circular reference. You can link this record to other records of the same type, but not the same record."
Why is this? Can I not have two records reference each other with a referential lookup relationship?
I know this is definitely possible. If I recall, the error is actually the result of a different relationship - one of the OOB fields - though I can't recall the specific one at the moment. To prove my point, as an example, if you create a custom entity, reciprocal relationships work fine. I'll think on this and if I remember the workaround, will be sure to fill you in.
If you've found this thread useful, dive deeper into User Group community content by role