I'm trying to get the maximum numeric value from one feature class and use that value in an expression to calculate values of a different feature class.
fc2.bldg_id = max(fc1.bldg_id)+1
Can this be done using the advanced field calculator? If so, what would my syntax look like? Do the feature classes need to be in the same fgdb and feature dataset?