Select to view content in your preferred language

Is there a way to edit the foreign key field in a related table in Field Maps?

813
2
11-04-2021 06:13 PM
WilliamMertens
New Contributor

Hi all,

I have a set of points with a related standalone table for tracking inventory items (laptops, furniture, etc.) in a school at the room level. In this case, UNIT_ID (per the ArcIndoors data model) serves as the key.

I'm intending for the staff members to use Field Maps to create and update item records, but reassigning an item to another room requires editing the foreign key. Field Maps, at least how I currently have it set up, does not allow you to edit the foreign key in a related table.

I would just create a duplicate field then update the foreign key using an attribute rule, but but my understanding is attribute rules aren't supported in AGOL (yet). The only workaround I can think of is to use a Notebook task to copy over a duplicate field, which is not ideal.

Is anyone aware of a solution to this or another workaround? I'd really like for the entire functionality of this system to work on mobile.

2 Replies
CAkoth
by
New Contributor

Hello, I'm currently experiencing this challenge. Did you find a solution? 

0 Kudos
AHand
by
New Contributor
I did some more digging after asking this question and found that Field Maps does not support changing the foreign key. You can change it in a web app if that workflow would work for you.
0 Kudos