nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Related Record Foreign Key

TravisBock1

When adding a new related record using the Edit widget the foreign key is not auto-populated.

For example I have a feature with a primary key. I click on the feature to get the edit popup and click the related records link at the bottom. Then, after clicking Add New Record, I am presented with the inputs for that table. Included is the foreign key field which is blank. It seems to me two things should happen. 1) The foreign key field should be auto populated with the current features primary key. 2)The foreign key field should be hidden. The second one I haven't attempted but I believe its relatively straight forward. But the first part I am surprised about.

So, am I missing something or the widget is not operating correctly.

Encuentra más publicaciones etiquetadas con

Accepted answers

SarthakDatt

Would it be possible to share the JSON for relationships for both the layer and its related table.

I looked into the code and the RelationshipInspector does try to populate the foreign key but I think right now it assumes the key field name to be the same in both the layer and related table. My guess is that in this case the two fields are different.

All comments

SarthakDatt

I have already done so. So now the primary key in the feature class matches the foreign key field name in the related tables and it is now working correctly.

You shouldn't be required to do it. This would be a workaround for now. I will put in a fix for the next version.

TravisBock1

This is a new geodatabase still in the dev phase. So changing the key field names is not an issue. I have already done so. So now the primary key in the feature class matches the foreign key field name in the related tables and it is now working correctly.

Thanks for the help!

Maybe it is just me but it seems like this should be explained somewhere. Or did I just miss it?

Travis

SarthakDatt

VickyS

I have the same issue. Any ideas ESRI?

Vicky

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.