I want to create a relationship class in which a field self-references another field in the same table. For example, fields of my CustomerRelation table are:
relationID (primary key)
customerID
parentCustomerRelationID (foreign key which points to relationID field in this table)
When I try to create a relationship class with the same table as origin and destination in ArcCatalog I get the following error:
"You cannot create a relationship class using the same object class as the origin and destination. Please select a different origin and/or destination object classes."
Is there any way to handle this kind of recursive foreign keys with relationship classes? Or can you suggest any other method to ensure data integrity for tables containing recursive foreign keys?
Thanks in advance.
nilgun
