Hi, I am running an SQL Geodatabase on my server and I have a point feature class in it. I would like to set up a string field that automatically updates containing the MGRS of the point. I am guessing I need to set up a trigger that is pulled on UPDATE, INSERT for the shape field. Would I have have to call a geoprocessing function such as Convert Coordinate Notation in order to calculate this field? Logically this workflow makes sense to me, but I don't know how to accomplish it as I'm fairly new to working with this type of geodatabase. I know how to set up a basic trigger, but nothing like this. Any help would be appreciated!
Joe
