How to fill attribute field of one feature based on calculation on attribute field of another feature and relate them so data gets updated when edited in the other feature class?

1590
4
04-11-2017 05:24 AM
niklasGregersen
New Contributor III

Hey folks,

I was wondering if it is possible to calculate a field in one feature class based on attributes in another feature class, and relate them so when I edit in my second feature class the calculated field in my first feature class gets updated automatically?

Thank you.

0 Kudos
4 Replies
JonathanQuinn
Esri Notable Contributor

Not an expert in that area but I think you'll need to use a database trigger of some sort.  That link is specific to SQL Server, so find the relevant docs for whatever DBMS you're using.

niklasGregersen
New Contributor III

Thank you  I will try and look more into it to see if that could be a solution.

0 Kudos
Greg_Mattis
Occasional Contributor II

Hi Niklas,

I would recommend looking at the attribute assistant tool for ArcMap. You are able to run rules with the attributes and two of them are to calculate field based upon intersecting feature and the other is to update intersecting feature. There is plenty of documentation here.

Greg Mattis, GISP
GIS Analyst
City of Visalia
0 Kudos
niklasGregersen
New Contributor III

Thanks, I will consider it if another case appear with same problem.

0 Kudos