Hi i need to update a table field based on the results of another field within the same table
I have a field call Short_ID the data within this Field can be either
K
ET
CR
N
NN
S9
S6
NSS
Need populate into an empty field the results
so If K put into Field Called "Short_ID_Group" as P
and ET should be the same but CR would be "C"
I have a field call Short_ID the data within this Field can be either
K
ET
CR
N
NN
S9
S6
NSS
Need populate into an empty field the results
so If K put into Field Called "Short_ID_Group" as P
and ET should be the same but CR would be "C"