How does esri relationship classes handle objectID connections?

365
2
01-30-2020 12:48 PM
MichaelThornton
New Contributor II

I want to use a relationship class GDB object to relate multiple (i.e. two) non-spatial tables (say table name 'Historical Records' and table name 'Recommendations')  to my feature layer. My concern is that if someone deletes a polygon and redraws it on a sde two-way replication connection for that feature layer, new objectIDs will be created on that feature layer and thereby breaking my connections between the non-spatial tables and my feature layer. Does ESRI have a way of handling this?

0 Kudos
2 Replies
George_Thompson
Esri Frequent Contributor

I would not use ObjectID's as the "joining" field for the relationship class.Relationship class properties—Help | ArcGIS Desktop .

--- George T.
0 Kudos
LorneDmitruk2
New Contributor III

Further to George's reply, ObjectID's should not be used as primary or foreign keys. For establishing relationships you're better off creating and using a GUID or your own primary key field.

0 Kudos