AnsweredAssumed Answered

Field Calculator based on another field in Table

Question asked by gjohnson_btv on Jan 10, 2014
Latest reply on Jan 10, 2014 by rfairhur24

I have joined a sewer Gravity Main (pipes) table to my Manholes table based on [From_Manhole]. My next step was using the field calculator set the values of [Upstream_Elevation] in my Gravity Mains table equal to the values of [Invert_Elevation] from the joined Manholes table. However, when I try to execute this function, I get an error message. Am I using the right expression? The input field and destination fields are both Double with a precision of 38... not sure if this matters?

Here is what the geoprocessing results showed me:

infrastructure.PUBLICWORKS.ssGravityMain.Upstream_Elev= [infrastructure.PUBLICWORKS.ssManhole.INVERTELEV]

General Error executing calculator
ERROR 9999999
Syntax error
Failed to execute