When Salesforce was set up in our organisation, the State text field part of the compound address was repurposed to store the City data instead (City field is being used for Suburb, since there isn't a field for this). We now have a problem in that we require a State field as well, and I was hoping to be able to use the StateCODE field, but this field doesn't show up when editing at all. Yet the documentation seems to indicate that it should be?
Are the 2 fields inseparable, ie we can't use the one without it being linked to the other? Changing the way things work would require a major code rework (to revert State = state and City = city). The alternative is just creating a custom field for State data.