Related Records in Hosted Feature Service in Map Viewer - can't add to Form?

AndreaB_ · ‎11-09-2023

Hi all,

I am following this blog post: https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/introducing-related-record-editing-i...

In my Forms I see the new 'Related records' element at the bottom. Unfortunately, when I expand the arrow down, I see "No related records available. Create new related records in ArcGIS Pro'.

Well that's not true because I have a related record and I also configured to see it in my pop ups!

soo, is this a bug? or anyone else have this problem and a way to solve it?

Thank you,

Andrea

bbollin · ‎11-13-2023

Alright, from taking a look at the service you sent me @AndreaB_ you actually have relationship configured where the table is the parent and the feature is the child.

Currently this is not supported in AGOL, but may be something we consider adding support for in the future. I would suggest swapping the order of the relationship so it goes from feature - table. Thanks!

View solution in original post

AndreaB_ · ‎11-13-2023

Thanks. Here is the new idea post I created: https://community.esri.com/t5/arcgis-online-ideas/map-viewer-forms-related-records-support-for-table...

Yeah, so in a simple relationship the table record will remain but I should have said - the foreign key will be changed to Null, introducing errors into the foreign key field. Understandably more of a problem with 1:M not so much in a 1:1, but still. I tested it with my data and a table record with the foreign key field changed to Null wouldn't help much if you were trying to tie it back to your data for some reason. That Esri documentation on this was helpful - https://pro.arcgis.com/en/pro-app/3.1/help/data/relationships/relationship-class-properties.htm

Thanks again!

View solution in original post

EmilyGeo · ‎11-09-2023

Hi @Andrea,

I apologize for the inconvenience you're facing. To assist you further, could you provide additional details?

Are you referring to a feature-to-feature or feature-to-table relationship?

When adding the related record element to the form, are you configuring the form for the parent feature or the child feature?

AndreaB_ · ‎11-10-2023

Hi @EmilyGeo,

Thanks for the reply. It is a feature-to-table relationship. I was configuring the form for the parent feature.

bbollin · ‎11-13-2023

Is this a 1-1, 1-M, or M-M cardinality @AndreaB_

bbollin · ‎11-13-2023

Also, would you be able to share your data with us so we can take a closer look

AndreaB_ · ‎11-13-2023

Sure, I took out most of the attributes so I can share it. It's a test layer anyway with just one feature and one record. How do you want me to share?

bbollin · ‎11-13-2023

@AndreaB_you can send me a direct message with the service, shared publicly

AndreaB_ · ‎11-13-2023

Hi @bbollin,

This is a 1-1. Thank you.

bbollin · ‎11-13-2023

Alright, from taking a look at the service you sent me @AndreaB_ you actually have relationship configured where the table is the parent and the feature is the child.

Currently this is not supported in AGOL, but may be something we consider adding support for in the future. I would suggest swapping the order of the relationship so it goes from feature - table. Thanks!

AndreaB_ · ‎11-13-2023

Hi @bbollin,

Thanks for figuring that out. I think we have our geodatabase relationship set up table as parent and feature as child to preserve the table records in case the feature is deleted - as described in this best practice help documentation. https://pro.arcgis.com/en/pro-app/3.1/help/data/relationships/relationship-class-properties.htm

For this particular case, I was just testing the new AGOL functionality and I'm not sure our workflow would use hosted feature services and editing features in that hosted relationship. I think if we need this functionality it would be more likely an Enterprise Portal related data feature service in an AGOL map. So we await that future enhancement to be available some day.

I would add my strong support for table - feature relationships in AGOL also. Is there an Idea already posted somewhere that you know of?

Thanks!