If you have a N:N relationship and try to associate two or more records at a time, there is an error thrown (below) but the association still takes place.
In this example I created a custom entity new_test with a N:N relationship to Marketing Lists. Trying to associate 2 or 3 marketing lists to my custom entity threw the error:
"Duplicate Record - A record with these values already exists. A duplicate record cannot be created. Select one or more unique values and try again."
The log file shows:
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Cannot insert duplicate key.Detail:
-2147220937
Cannot insert duplicate key.
2014-04-02T16:17:28.322493Z
Comments
Thanks for the feedback this product suggestion looks like it is a bug not a suggestion. We have made note of the issue, this item will be closed out as postponed and this is a bug not a feature. Please use the following link https://community.dynamics.com/crm/p/support.aspx to enter a support case if you would like to make sure to have the issue tracked more closely. Thanks for the feedback. Larry
Category: Account, Contact, Calendar and Activity Management
Larry, I know this is a bug. That is why I reported it in the title as "MVP Bug". Please talk to Shilpa Sinha on the CRM product team. This is the process that MVPs have been given to report bugs.
Category: Account, Contact, Calendar and Activity Management
Administrator
Thank you for submitting your idea to our ideas portal. We appreciate your contribution and the time you took to share it with us. We have shipped many enhancements since this idea was posted and it is likely that it has been resolved. If not, kindly reopen. Thank you again for your continued support.