Customer experience | Sales, Customer Insights,...

How to Create 1:1 Relationship between two entities?

(1) Share

Report

Posted on by CU10101039-0

Hello Friends,

I am new to MS Dynamics currently using version 8.2 (2016) on premise edition. My technical background is pure .NET Developer.

Can anyone explain me with a very simple example on how to create one-to-one relationship between two entities? (Sample Image is attached for my understanding)

Thanks.

ER.PNG

All responses (2)

Answers (0)

Suggested answer

Muhammad.Affan 4,449 on at

Like (6)

Report

How to Create 1:1 Relationship between two entities?

Hi There,

Refer to this link it provides overview of entity relationship in D365.

https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-entity-relationships?view=op-9-1

Thanks

Affan

If my answer please mark it as verified.
Suggested answer

Ray 1,505 on at

Like (0)

Report

How to Create 1:1 Relationship between two entities?

Dynamics does not support 1:1 relationship directly.

But you can do some customization on 1:N or N:N relationship, an usually way is to create a plugin to limit the create/update of the entity records.

In your example, you can create a 1:N relationship between Employee and Employeedetail. And then create a plugin on the "N" entity for create and update message, to limit the records point to the "1" entity.

BTW, If you want to dispaly the EmployeeDetail info on Employee form, then you can consider use Employee as the "N" entity in 1:N relationship(lookup field), this will allow you to use a quick view form to display the EmployeeDetail.