Self-referencing Relationship Class

[JoeGerner]

I want to create a relationship class for a table in an ArcSDE in ArcGIS Pro 3.3. This class should reference itself. The class contains pipes, and any number of other pipes can be contained within a single pipe, hence the self-referencing. The table contains a GlobalID and a ParentGlobalID.

However, ArcGIS Pro always gives me an error message, regardless of the configuration I use.

The screenshot shows my configuration and also a screenshot of the error message.

How can I correctly create a self-referencing relationship?

[AyanPalit · Accepted solution]

@JoeGerner Looks like you want to setup 'Recursive Relationships' which is not supported. Suggest  exploring workarounds to avoid self-referencing loops, intersection/cross-reference tables for many-to-many relationships, or flattening hierarchies.

REF:  Limitations of relationship classes