All,
I am Using SQL Server 2008 R2.
I have a spatial table in my geodatabase in database A.
I have a non-spatial table in database B.
Both databases reside on the same server.
My goal is to open the Spatial feature in ArcGIS, create new features and have the non-spatial table also create new records.
I tried to use a relationship class but this only works when the two tables are in the database A.
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.
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
Thanks in advance
Gordon
