# Country/region table - best practice

**URL:** <https://www.dynamicsuser.net/t/country-region-table-best-practice/28903>\
**Category:** User Forum\
**Created:** [January 25, 2011, 1:33am UTC](https://www.dynamicsuser.net/t/country-region-table-best-practice/28903 "2011-01-25T01:33:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jbrad627](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jbrad627](https://www.dynamicsuser.net/u/jbrad627)\
**Post date:** [January 25, 2011, 1:33am UTC](https://www.dynamicsuser.net/t/country-region-table-best-practice/28903/1 "2011-01-25T01:33:13Z")

</div>

Looking for both examples and advice on how the Country/region table should be used.

We understand the ISO code. It is more the Country/region and Description that get a little fuzzy.

How do you use the Country/region (COUNTRYREGIONID)? Do you use the ISO code, do you use a shorter version of Description (China rather than P.R. China, etc) or a different option?

If you use tags with the country of origin on them, do you use the Country/region or Description?

Some examples, what do you have for country/regionid for Canada, Switzerland, India?

How would you set up Tahiti?

Thank you

John