I just spent 2 weeks(!!) cleaning up a lookup table in a third-party ERP application that allowed (and still allows, but for the now-rescinded, application level user permissions) free-form entry for states and countries.

Fun fact: the United States of America has 786 states within its borders, including China, Formosa, Bhopal, and Chicago.

Referential Integrity??? "We don't need no stinkin' referential integrity!!!":smooooth:

Rich