topic Joining a FC to a non-spatial relational Database in Data Management Questions https://community.esri.com/t5/data-management-questions/joining-a-fc-to-a-non-spatial-relational-database/m-p/705253#M39961 <HTML><HEAD></HEAD><BODY><SPAN>Not sure if this is the right forum, but it seemed to make sense to me. A bit of background; we are contemplating creating a database to handle/store historical transactions which will be maintained with an interface outside of ArcGIS. </SPAN><BR /><BR /><SPAN>I choose/desire to step outside the geodatabase for this information because there are limitations in the hierarchical design and relationships within the GDB, the interface for the required updates is comparatively cumbersome and time consuming, and having external (non ArcGIS interface) editing against the GDB leaves me feeling uneasy. For these reasons, it makes sense to me to have this information contained within a separate database. </SPAN><BR /><BR /><SPAN>I know you can make joins to specific </SPAN><SPAN style="font-style:italic;">tables</SPAN><SPAN> within another database, but can you access the relational functionality/behavior contained within them through a join?</SPAN><BR /><BR /><SPAN>Does anyone work with a similar scenario like this?</SPAN></BODY></HTML> Wed, 03 Apr 2013 13:41:56 GMT ZacharyHart 2013-04-03T13:41:56Z Joining a FC to a non-spatial relational Database https://community.esri.com/t5/data-management-questions/joining-a-fc-to-a-non-spatial-relational-database/m-p/705253#M39961 <HTML><HEAD></HEAD><BODY><SPAN>Not sure if this is the right forum, but it seemed to make sense to me. A bit of background; we are contemplating creating a database to handle/store historical transactions which will be maintained with an interface outside of ArcGIS. </SPAN><BR /><BR /><SPAN>I choose/desire to step outside the geodatabase for this information because there are limitations in the hierarchical design and relationships within the GDB, the interface for the required updates is comparatively cumbersome and time consuming, and having external (non ArcGIS interface) editing against the GDB leaves me feeling uneasy. For these reasons, it makes sense to me to have this information contained within a separate database. </SPAN><BR /><BR /><SPAN>I know you can make joins to specific </SPAN><SPAN style="font-style:italic;">tables</SPAN><SPAN> within another database, but can you access the relational functionality/behavior contained within them through a join?</SPAN><BR /><BR /><SPAN>Does anyone work with a similar scenario like this?</SPAN></BODY></HTML> Wed, 03 Apr 2013 13:41:56 GMT https://community.esri.com/t5/data-management-questions/joining-a-fc-to-a-non-spatial-relational-database/m-p/705253#M39961 ZacharyHart 2013-04-03T13:41:56Z