International Values for "States" Table

Brittany ODowd

Hi all,

We recently converted to RE/RENXT and the data that we brought over was a hot mess. In cleaning up the States table, we have a lot of international cities, countries, and territories mixed together. I'm inactivating (and eventually correcting the addresses of) the obviously incorrect values. But, we do have a lot of international folks in our system, so I'm wondering how others have handled international addresses and tables.

Alan French

We have a similar issue but with the Counties table rather than States (we're in the UK). We also have a lot of international addresses in the system, especially Chinese, and the way I've handled it is to have all the UK counties at the top of the list, then a 'fake' county labelled ---CHINA (provinces)--- to mark the start of that section and then all the provinces underneath.