topic Re: How does esri relationship classes handle objectID connections? in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/how-does-esri-relationship-classes-handle-objectid/m-p/809040#M3069 <HTML><HEAD></HEAD><BODY><P>I would not use ObjectID's as the "joining" field for the relationship class.<A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/relationships/relationship-class-properties.htm#GUID-C4FA49CB-0841-4F63-8A08-B05DD6FA6FA4" title="https://desktop.arcgis.com/en/arcmap/latest/manage-data/relationships/relationship-class-properties.htm#GUID-C4FA49CB-0841-4F63-8A08-B05DD6FA6FA4">Relationship class properties—Help | ArcGIS Desktop</A>&nbsp;.</P></BODY></HTML> Thu, 30 Jan 2020 20:55:38 GMT George_Thompson 2020-01-30T20:55:38Z How does esri relationship classes handle objectID connections? https://community.esri.com/t5/geodatabase-questions/how-does-esri-relationship-classes-handle-objectid/m-p/809039#M3068 <HTML><HEAD></HEAD><BODY><P><SPAN>I want to use a relationship&nbsp;class GDB object to relate multiple (i.e. two) non-spatial tables (say table name 'Historical Records' and table name 'Recommendations')&nbsp; 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&nbsp;ESRI have a way of handling this?</SPAN></P></BODY></HTML> Thu, 30 Jan 2020 20:48:22 GMT https://community.esri.com/t5/geodatabase-questions/how-does-esri-relationship-classes-handle-objectid/m-p/809039#M3068 MichaelThornton 2020-01-30T20:48:22Z Re: How does esri relationship classes handle objectID connections? https://community.esri.com/t5/geodatabase-questions/how-does-esri-relationship-classes-handle-objectid/m-p/809040#M3069 <HTML><HEAD></HEAD><BODY><P>I would not use ObjectID's as the "joining" field for the relationship class.<A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/relationships/relationship-class-properties.htm#GUID-C4FA49CB-0841-4F63-8A08-B05DD6FA6FA4" title="https://desktop.arcgis.com/en/arcmap/latest/manage-data/relationships/relationship-class-properties.htm#GUID-C4FA49CB-0841-4F63-8A08-B05DD6FA6FA4">Relationship class properties—Help | ArcGIS Desktop</A>&nbsp;.</P></BODY></HTML> Thu, 30 Jan 2020 20:55:38 GMT https://community.esri.com/t5/geodatabase-questions/how-does-esri-relationship-classes-handle-objectid/m-p/809040#M3069 George_Thompson 2020-01-30T20:55:38Z Re: How does esri relationship classes handle objectID connections? https://community.esri.com/t5/geodatabase-questions/how-does-esri-relationship-classes-handle-objectid/m-p/809041#M3070 <HTML><HEAD></HEAD><BODY><P>Further to George's reply, <A href="https://support.esri.com/en/technical-article/000012462">ObjectID's should not be used as primary or foreign keys</A>. For establishing relationships you're better off creating and using a GUID or your own primary key field.</P></BODY></HTML> Thu, 30 Jan 2020 21:29:14 GMT https://community.esri.com/t5/geodatabase-questions/how-does-esri-relationship-classes-handle-objectid/m-p/809041#M3070 LorneDmitruk2 2020-01-30T21:29:14Z