I have a scenario where I am receiving non-spatial data in tabular form. I have imported this data into ArcSDE as a SDE Table. The table is named Incident_Details structure contains columns: Incident_ID (Global ID would be used in the Prod scenario), Description
I would like to represent the records within this table spatially via a Relationship Class.
I have then created a point Feature Class named Incident_Point within the same ArcSDE database with just one column: Incident_ID (Related_Global ID would be used in the Prod scenario) plus Shape, OBJECTID
I have then created a Relationship Class with the following details-
Cardinality: One to Many (so many points can be related the one incident)
Origin: Incident_Details (non spatial Table) with Primary Key = Incident_No (Global ID would be used in the Prod scenario)
Destination: Incident_Point (point feature class) Incident_No as Foreign Key (Related_Global ID would be used in the Prod scenario)
Suppose the Incident_Details (non spatial Table) has just one record with Attributes: Incident_No = 999, Description = First incident
I want to now be able to open both the Incident_Details table and Incident_Point within ArcMap and Create a new point that has a relationship with the Incident_Details record where Incident_No = 999. I do not want to do this by manually entering Foreign Key Incident_No = 999 for the newly created point.
I want to be able to start with the record within ArcMap in the Incident_Details table, click it and 'Create new related record'. IE via a right click within the attribute table and 'Create new related record':
This question may be redundant because as far as I am aware the functionality I envisage does not exist within the ArcMap-ArcGIS Server or AGOL environment.
I have good experience where the Origin is a spatial feature class within a Relationship Class but not where the Origin is a non-spatial table.
If anyone has any insight into this query that would be great.