topic Updating Non-spatial table in second database from ARcGIS in Data Management Questions https://community.esri.com/t5/data-management-questions/updating-non-spatial-table-in-second-database-from/m-p/445686#M25496 <HTML><HEAD></HEAD><BODY><SPAN>All,</SPAN><BR /><BR /><SPAN>I am Using SQL Server 2008 R2. </SPAN><BR /><SPAN>I have a spatial table in my geodatabase in database A. </SPAN><BR /><SPAN>I have a non-spatial table in database B.</SPAN><BR /><SPAN>Both databases reside on the same server.</SPAN><BR /><BR /><SPAN>My goal is to open the Spatial feature in ArcGIS, create new features and have the non-spatial table also create new records.</SPAN><BR /><SPAN>I tried to use a relationship class but this only works when the two tables are in the database A.</SPAN><BR /><SPAN>I created an SDE view from Database B to Database A and then included this in a relationship class. While this allowed me to edit the existing records in the non-spatial table it did not allow me create new records when I created new spatial records.</SPAN><BR /><BR /><SPAN>Is there a way I can update the non-spatial table in Database B when I modify existing records or create new records in the Spatial Table in database A</SPAN><BR /><BR /><SPAN>Thanks in advance</SPAN><BR /><SPAN>Gordon</SPAN></BODY></HTML> Tue, 13 Nov 2012 23:43:38 GMT GordonSumerling 2012-11-13T23:43:38Z Updating Non-spatial table in second database from ARcGIS https://community.esri.com/t5/data-management-questions/updating-non-spatial-table-in-second-database-from/m-p/445686#M25496 <HTML><HEAD></HEAD><BODY><SPAN>All,</SPAN><BR /><BR /><SPAN>I am Using SQL Server 2008 R2. </SPAN><BR /><SPAN>I have a spatial table in my geodatabase in database A. </SPAN><BR /><SPAN>I have a non-spatial table in database B.</SPAN><BR /><SPAN>Both databases reside on the same server.</SPAN><BR /><BR /><SPAN>My goal is to open the Spatial feature in ArcGIS, create new features and have the non-spatial table also create new records.</SPAN><BR /><SPAN>I tried to use a relationship class but this only works when the two tables are in the database A.</SPAN><BR /><SPAN>I created an SDE view from Database B to Database A and then included this in a relationship class. While this allowed me to edit the existing records in the non-spatial table it did not allow me create new records when I created new spatial records.</SPAN><BR /><BR /><SPAN>Is there a way I can update the non-spatial table in Database B when I modify existing records or create new records in the Spatial Table in database A</SPAN><BR /><BR /><SPAN>Thanks in advance</SPAN><BR /><SPAN>Gordon</SPAN></BODY></HTML> Tue, 13 Nov 2012 23:43:38 GMT https://community.esri.com/t5/data-management-questions/updating-non-spatial-table-in-second-database-from/m-p/445686#M25496 GordonSumerling 2012-11-13T23:43:38Z