Setting Primary Key

(0) Share

Report

Posted on by CRMexplorer

760

Hi,

Does anyone know how to set the primary key in entities. I want to create an ID for each record in account, how can I set that field as the primary key?

Thank you in advance

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

chikhaleankush 547 on at

Like (0)

Report
Hey Rachelle,

When the Entity is created, it does have a already built Primary Field. You do not externally need to create it. Also when you create a record for a Entity, Guid (Id) will be also automatically set. But if you want to set a lookup filed Then you need Guid, Name and Logical Name of the record.

Below code might be of help!!!

var lookup = new Array(); lookup[0] = new Object(); lookup[0].id = recorid; lookup[0].name = recordname; lookup[0].entityType = entityname; Xrm.Page.getAttribute("attributename").setValue(lookup);

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

If you are creating a new record in the system, it will automatically set the Guid for you, however, if you are importing data, and you want to set the Guid yourself you can do it either from the SDK (using C#/.NET code), by supplying the Guid of the record, or if you are using SSIS with KingswaySoft for example, you can specify the Guid of the record that you will be creating there.

Hope this helps.

Was this reply helpful? Yes No
Verified answer

Hemant Kumar Sahu 1,829 on at

Like (1)

Report

Hi RachelleM,

You can create a key field this will be alternate key but wont be primary key but acts as primary key. As we can have only one Primary key.

Please follow below links to generate GUID dynamically.

https://weblogs.asp.net/haithamkhedre/generate-guid-from-any-string-using-c
http://www.c-sharpcorner.com/UploadFile/prasoonk/guids-in-C-Sharp-and-net/

Thanks
Hemant

Was this reply helpful? Yes No