Dynamics Community Forum Thread Details

1:1 Relationships - changing what appears in the field with jScript?

Say I want to create a Country entity. Imagine I do it with the following attributes:

ISO_3166-1 Code (this is the primary key)
Name (English)
Nombre (Spanish)
Nom (French)

Now, I would like to make a 1:1 relationship with the Account and Contact entities for a start.

Thing is, I would like the value that should appear in the lookup to be Either the name of the country in French, English or Spanish, depending on the language the user is using.

Here is an example of what I was thinking for a multi-language deployment using a Country entity:

Create an entity with the following values
a) ISO 3166-1 Alpha 2 Code [this is the primary identifier]
b) Name (English)
c) Nombre (Castellano)

The idea is to have support for Country names in both English and Spanish (Castellano)
Edit the lookup for this Country entity and allow searching by Nombre (Castellano) and Name (English)
Add a sample country in the list with the values
a) ISO 3166-1 Alpha 2 Code: UK
b) Name (English): United Kingdom
c) Nombre (Castellano): Reino Unido
Add the relationship with the Account entity and add it into the Account form.
As a test, search in the new Country field for either UK, REINO UNIDO or UNITED KINGDOM, and the field should return the value UK.

PROBLEM: How could I configure the system so it show instead of UK, the country name (Reino Unido or United Kingdom) based on the current locale loaded in CRM?

Is there a way to do such using jScript and form/field events?

Thanks in advance.

Regards,
P.

Quick Links

Leaderboard