So my table consists of multiple fields, lets say field 1 is labeled "purpose" and has 20 unique values. Of those 20 unique values two are "multi family," and "multi family <10".
Now I created a new field named "XXX" I want to calculate this new field with a new values ).
So where field 1 = multi family i want field two to = mf. where field 1 value = multi family <10' i want field two to = mf.
if field 1 == 'multi family' then write new value for field two as 'mf'
I am trying to write an expression (was using python but if you can help with vb.script that would work as well) in the field calculator tool.
Hope this better explains my situation.