Update many-to-many relationship through selected items

[Service_SIG_CAPDFT]

Hello,

I'm trying to create an Experience Builder application that allows a field agent performing an intervention on a network to link this intervention to the actual network segments involved.

The data consists of a point feature class called "interventions" and a line feature class called "network". Naturally, a network segment can be involved in multiple interventions, and a single intervention can concern multiple segments. Therefore, a many-to-many (M:N) relationship has been defined in the database.
The datas had been published as a service on our enterprise server then used through URL in Online portal.

Since it's not possible to know in advance which segments are involved, only the team leader in the field can determine which ones are affected. As the teams are not GIS experts, I believe the most user-friendly way to enter the data is to allow them to select the segments directly on the map then clic an "update" button.

In ArcGIS Pro, it's simply a matter of selecting the "intervention" and "network" features, then using the attribute pane and the tool "Add selected item to the relationship".https://pro.arcgis.com/en/pro-app/latest/help/data/relationships/populate-an-attributed-relationship...

Now I'm trying to replicate this action in Experience Builder (or in ArcGIS Online more generally).

The solution suggested by ChatGPT was to develop a custom widget, but I currently don't have the time or skills for that...

I'm open to any ideas.
Thank you.

[Allen_Zhang]

Hi @Service_SIG_CAPDFT 

Have you tried the Edit widget's map mode? It supports editing related records.

[Gene_Sipes]

What is this map mode? How do you enable that?

[Service_SIG_CAPDFT]

I'm using an old version 10.9.1 of enterprise.
Related records are supported natively on published data from 11.2 enterprise.
I will have an update this autumn and will try the soltution.
Thx

[Gene_Sipes]

I want to do this same thing! What is the solution?

[Allen_Zhang]

[EvanManrow]

This doesn't work for many-to-many related tables. There isn't any way to add them to the Edit Form. Neither Map Viewer nor Field Maps allows it.

I say this somewhat over-confidently, in the hopes that someone will correct me with a working solution — but after spending this week fighting the issue, I'm pretty confident it's impossible. 😕

[Allen_Zhang]

It's true.

[Gene_Sipes]

Not that it helps your particular workflow, but have you tried this with a hosted feature service? 

[EvanManrow]

Using a hosted feature service (via "Publish Web Layer" in Pro) gets one step closer: it will at least show the many-to-many records reliably in Popups. That doesn't really make sense to me, since I have to add the Service to a Web Map to load it into EB anyway.

But without a way to add the Relationship to a Smart Form on the feature layer, there is no way to edit the relationships in AGOL. From the intermediate Table I can delete records, and from the Related Table I can add new features to the related Feature Layer, but I can't associate existing Features and Records.