News and Announcements icon

Dynamics 365 CommunityForums Customer Service forum Relationships between ...

Customer Service forum

Relationships between custom and system entities

(0) Share

Report

Report

Posted on by Angel Arteaga

155

Hi Dynamics Experts,

I'm currently customizing a Dynamics 365 Sales instance (Online) and I've created a custom entity named "Insurance coverage" that is related to account entity (N:N Many-to-Many), then when I create an Insurance coverage I can select wich accounts im offering this insurance, but, this insurance doesn't apply for every contacts in those acounts, I need to add a contact grid in my insurance coverage form where I can select wich contacts applies for this insurance, this grid must show only the contacts related to the accounts that I've choose previosly.

What approach sholud I follow? How can achieve it. Any suggestions are most welcomed.

Thanks in advance!

Categories:

Customer Service

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Armine DD 280 on at

Like (0)

Report

RE: Relationships between custom and system entities

Hi Angel, to cover the business requirement you described, you would need a 1:N /if one Insurance coverage is related to many contacts/ or N:N /if one Insurance coverage is related to many contacts/ relationship, other wise you cannot add a subgrid in the custom form of Insurance coverage and you cannot select a contact. In schema you created, Account is the parent for all underlying Contacts, so the Insurance coverage relates to all of the contacts/if I get this right/. I would suggest you delete the N:N to Account and create a relationship to Contacts instead.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans