https://community.esri.com/t5/arcgis-dashboards-questions/spatial-data-in-related-tables/m-p/1020179#M4152 <P>I have a main table with ProjectID and Name. ProjectID is the foreign key in 2 (or more) 'geometry' tables as a Project can have points AND lines associated with it. The screenshot is from ArcPro. The tables are shown in the screenshot as well.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SeanChew88_0-1611684383714.png" style="width: 600px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/4589iC2DCE4A52373F3B2/image-dimensions/600x297?v=v2" width="600" height="297" role="button" title="SeanChew88_0-1611684383714.png" alt="SeanChew88_0-1611684383714.png" /></span></P><P>What I'd like is to have these show up as a unified dataset (from user's perspective) in ArcGIS Online webmaps (could be done through a temporary join?). When a feature (point or line) is clicked, it brings up Project Name, and a user can edit Name (in the Projects table) corresponding with the selected feature. I'm not familiar with how to do this in ArcPro/ArcGIS Online.</P><P>I'd rather not replicate Name across all related tables as that leads to data integrity issues, and changes in one layer (point) won't reflect in the others (line).&nbsp;In an SQL database (which I'm familiar with), it'd be something like<BR /><EM>Update Projects set Name = 'NewProjectName' where ProjectID = [ProjectID of clicked/selected point or line]</EM></P><P>Any documentation on how to do something like that in ArcPro/ArcGIS Online webmaps/webapps? TIA!</P> Tue, 26 Jan 2021 18:52:49 GMT SeanChew88 2021-01-26T18:52:49Z https://community.esri.com/t5/arcgis-dashboards-questions/spatial-data-in-related-tables/m-p/1020179#M4152 <P>I have a main table with ProjectID and Name. ProjectID is the foreign key in 2 (or more) 'geometry' tables as a Project can have points AND lines associated with it. The screenshot is from ArcPro. The tables are shown in the screenshot as well.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SeanChew88_0-1611684383714.png" style="width: 600px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/4589iC2DCE4A52373F3B2/image-dimensions/600x297?v=v2" width="600" height="297" role="button" title="SeanChew88_0-1611684383714.png" alt="SeanChew88_0-1611684383714.png" /></span></P><P>What I'd like is to have these show up as a unified dataset (from user's perspective) in ArcGIS Online webmaps (could be done through a temporary join?). When a feature (point or line) is clicked, it brings up Project Name, and a user can edit Name (in the Projects table) corresponding with the selected feature. I'm not familiar with how to do this in ArcPro/ArcGIS Online.</P><P>I'd rather not replicate Name across all related tables as that leads to data integrity issues, and changes in one layer (point) won't reflect in the others (line).&nbsp;In an SQL database (which I'm familiar with), it'd be something like<BR /><EM>Update Projects set Name = 'NewProjectName' where ProjectID = [ProjectID of clicked/selected point or line]</EM></P><P>Any documentation on how to do something like that in ArcPro/ArcGIS Online webmaps/webapps? TIA!</P> Tue, 26 Jan 2021 18:52:49 GMT https://community.esri.com/t5/arcgis-dashboards-questions/spatial-data-in-related-tables/m-p/1020179#M4152 SeanChew88 2021-01-26T18:52:49Z