Create An Index on Entity

(0) Share

Report

Posted on by Community Member

I would like to enforce uniqueness on an Entity using a Field that is a string in combination with a field that is an optionset. When I go to the 'Keys' -> 'New' section I only see the a string field as an available attribute. Is it possible to enforce in this way or is there another way inside CRM to accomplish this

*This post is locked for comments

All responses (3)

Answers (1)

Suggested answer

a33ik 84,325 Most Valuable Professional on at

Like (0)

Report

RE: Create An Index on Entity

As a workaround - check second part of my reply. There is the only workaround I see.
Community Member on at

Like (0)

Report

RE: Create An Index on Entity

Thanks for the reply Andrew! Thats pretty much what I gathered from the documentation. Is there a workaround for this? I was thinking something like creating a field that is somehow mapped to the optionset value.

Something else Im not thinking of? I really dont know the ins and outs of Dynamics. Thanks again!
Verified answer

a33ik 84,325 Most Valuable Professional on at

Like (1)

Report

RE: Create An Index on Entity

Hello,

I'm afraid that string, whole number and decimal are only valid fields for usage as alternative key - msdn.microsoft.com/.../dn932139.aspx

What you can do - you can create hidden field and populate it with optionset's label and use that combination of 2 fields as alternative key.