Hello, I have the following problem with CRM Dynamics 2013:
Consider the Lead entity and a custom entity called "Preferred Language" (with just a "name" attribute).
The situation is that one Lead can have multiple Preferred Languages, and a Language can be shared by multiple Leads. Hence, I set up an N:N relationship.
But there is more: a Lead can be linked to a Language with a optional "Knowledge Level" (see http://en.wikipedia.org/wiki/Common_European_Framework_of_Reference_for_Languages). For example, the lead John has English as preferred language with a C1 level.
In a common SQL environment, I would add this attribute to the NN relationship itself. So the dedicated table will be composed by three columns: Lead ID, Language ID and Level.
How can I achieve this on the CRM 2013? I was looking for a "fields" section in the Relationship editor, but I can't find anything.
Thanks for the support.
*This post is locked for comments
I have the same question (0)
