Customer experience | Sales, Customer Insights,...

N:N relationship entities not in edit column record type

(0) Share

Report

Posted on by J_C

Hi all,

My company entity and marketing list entity have an N:N relationship. however, when i go advance search and edit columns i do not see marketing list as a record type to link. i've check the relationship settings as below. I've tried getting up a custom N:N relationship and display gettings on and searchable on, but that still did not resolve the issue.

My goal is to search for all companies by marketing list, whether its blank or not.

Thanks in advance,

All responses (2)

Answers (0)

Amit Katariya007 8,506 Super User 2024 Season 1 on at

Like (0)

Report

RE: N:N relationship entities not in edit column record type

Hi,

That is correct you will only able to see N:1 or N:1 relationship in dynamics 365 from the views.

If you want to use the N:N relationship then you can use the "XRM Toolbox". Please refer below link for the Fetch XML builder from which you will able to see N:N relationships and check the data.

Link : www.xrmtoolbox.com/.../

Thank you,

Amit Katariya
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: N:N relationship entities not in edit column record type

Hi,

Yes, N:N relationship entities won’t show in the edit column of the view and there is no way to achieve this.

You can add a Subgrid in the form to get all companies from one row of Marketing list.