File GDB relationship classes in ArcGIS Diagrammer

EricGoddard — Sun, 23 Oct 2011 12:33:31 GMT

I'm attempting to setup a relationship class in a File Geodatabase (ArcGIS10)
between a feature class and a table using ArcGIS Diagrammer. After connecting
the relationship object to both the origin class and the destination class,
the origin's attributes are selectable in the OriginPrimary and OriginForeign
fields, however the attributes for the DestinationForeign and DestinationPrimary
fields are empty. The relevent details for the Relationship Class are below:

BackwardPathLabel:        OriginTable
Cardinality:                      esriRelCardinalityOneToMany
ClassKey                        esriRelClassKeyUndefined
DestinationForeign:          (None) *This shows and empty list instead of the destination attributes
DestinationPrimary:          (None) * Again, empty list
ForwardPathLabel:           DestinationTable
IsComposite:                   False
IsReflexive:                     False
KeyType:                         esriRelKeyTypeSingle
Notification:                      esriRelNotificationBoth
RelationshipRules:           (Collection)

I created a relationship class in ArcCatalog and exported the database schema so that I could
see how the 2 schemas differed, but the schema with the relationship defined in arcCatalog
had the same issue when viewed in Diagrammer.

Any advice on how to create the relationship class in diagrammer would be greatly appreciated. Thanks!

Re: File GDB relationship classes in ArcGIS Diagrammer

EricGoddard — Tue, 25 Oct 2011 20:01:16 GMT

Besides mistaking the destination primary key for the origin foreign key, my problem was solved by looping through the Create Relationship Class tool in a python script.

topic File GDB relationship classes in ArcGIS Diagrammer in Data Management Questions

File GDB relationship classes in ArcGIS Diagrammer

Re: File GDB relationship classes in ArcGIS Diagrammer