Create relates in Arc Map Viewer in AGOL

[JamesBuckle]

Hello, 

I have a project in ArcPRO in which i created 'relates' which link my related tables to my layer. However, when I go to publish this as a web service and view the map in mapviewer, those relates seem to dissapear. Is there a way to ensure those relates are carried through to map viewer, or is there a way to create them within mapviewer itself?

Can anyone please advise?

Thanks

[bbollin]

@JamesBuckle  Hi James, the relationship should still be on your hosted feature service. Are you trying to see it in the pop-up or editor?

Check out these articles to explain how to set that up.
https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/introducing-related-record-editing-i...
https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/rolling-out-related-records-in-map-v...

If this doesn't help let me know

[JamesBuckle]

Hi, thanks for the advice. 

The first option above doesn't seem to work for me, as it says there are no related records available and i should create them in ArcGIS Pro. However as shown in the screenshot below, the relates do exist in arcpro:

The second option doesn't seem to work either as i don t have the option to add rel;ated records in the pop ups pane:

Just to clarify my set up, I have my layer and 5 tables as shown below:

[EmilyGeo]

Hi @James, 

Did you create a relate or a relationship class?

A relationship class exists in the geodatabase and will carry through the feature service to ArcGIS Online. Here is a link to an article explaining relates and relationship classes.

[JonJones1]

Hello,

I have a few questions regarding the use of relationship classes in ArcGIS Pro and their integration with AGOL (ArcGIS Online). Firstly, I'd like to know which version of ArcGIS Pro is required to create relationship classes. I'm under the impression that the basic version may not support this feature, is that correct?

Secondly, I'm seeking guidance on how to publish a layer, along with its related tables, to AGOL. Is it possible to publish everything, including the tables, directly to AGOL as a web layer through ArcGIS Pro, or is there a different method? Additionally, would I need to publish the entire Geodatabase to achieve this?

Another important question is about updating the tables on AGOL. For instance, if the original table data is sourced from an Excel file and I receive an updated version of this file, how can I update the corresponding tables on AGOL?

I apologize for the barrage of questions. I've attempted this process twice before, but encountered several obstacles. My workaround has been to add the data from these tables as fields to a single feature, which is far from ideal. I'm hoping to find a more efficient and correct way to do this. Surely, there must be a blog post or video tutorial on ArcGIS that explains this process?  

Thank you in advance for your assistance.

[bbollin · Accepted solution]

@JonJones1 
1. You can create and publish a relationship class in ArcGIS Pro. Here is a really helpful video https://www.youtube.com/watch?v=Fo9tP9qkm8k that goes through the entire process step by step.

2. You need to create the relationship class, tables, and/ or feature classes within the same geodatabase. Then once you have everything set up in your Pro map how you like it, simply publish the web map (documentation here https://pro.arcgis.com/en/pro-app/3.1/help/sharing/overview/share-a-web-map.htm).

3. For the last part of your question regarding updating your data, you can do this via Update data https://www.esri.com/arcgis-blog/products/arcgis-online/data-management/updating-data-in-arcgis-onli... A key part of this workflow is ensuring you have a unique ID field to easier match the old and new dataset. See the article I linked for more details.

[JonJones1]

Hey! This is exactly what I needed to know. I always got the second step wrong. I used to have ArcGIS Standard; now, I only have Basic, but I believe my problem was trying to save the layer only to AGOL. I didn't realize I had to save the entire webmap which uploads the full geodatabase. 

With that said, and thank you again, I am guessing, almost positively, that once I publish the webmap, I can use that feature layer in other webmaps besides that one in AGOL, right? I just wanted to double-check.

[bbollin]

Yes, just make sure if you have related tables and features layers everything is in the map. To view the records in editor and pop-ups make sure you review those articles I listed previously to get up and running in ArcGIS Online

[doronwen]

@bbollin I was trying to follow your solution, but I do not see how it solves the issue for a hosted feature layer (with unique records) and a related table with multiple records for each feature (one-to-many relationship).

When I try to use the Update Data option, and it asks me "Select the fields used to match the layer's unique identifier to the uploaded data." and I do not see the matching ID's that I originally setup as an option (all I see is objectid from my hosted feature layer and some random fields from my excel file)

A user posted this blog - Setting up a related table for Data Collection in ArcGIS Online and Experience Builder - which should work for me. But I do not see my related table in the Forms tab in Map Viewer.

My hosted feature layer has one-to-many relationship to the table and I see the relationship in ArcGIS online (under the hosted feature layers' Data > Fields tab). But Map Viewer is not picking it up. Any ideas how to solve it? Thanks

[bbollin]

Hi @doronwen, I'm a bit confused as to which part of the process is tripping you up. Is it that the related tables' field for a Unique Identifier does not appear as an option? Since it is a one-to-many this seems expected since the same parent ID would be repeated more than once for any related table records.

Is it that the relationship is not showing up in the Forms/editor widget in Map Viewer? If so, this blog shows how to configure the relationship in the form for Map Viewer: https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/introducing-related-record-editing-i...

Please let me know if this answers your question!