Dynamics Community Forum Thread Details

Hi All,

I have a requirement to get the records from Distributor entity to Account entity sub gird using fetch XML and Distributor entity has N:N relationship with Account. In a Account and Business Channel entity have 1 :N relationship

Distributor --Account --> N:N

Account - Business Channel--> 1:N

Business Channel- Distributor --> N:N

based on the Business Channel lookup on Account record , how to filter Distributor entity records using fetchXML.

Note : Business Channel entity have relationship with Business Channel upto 3 levels.

Regards,

Prakash M

Hi Prakash,

Can you provide more detailed information for following questions?

What records you want to get? Distributor?
What filter you need use?
“based on the Business Channel lookup on Account record”, “Account - Business Channel--> 1:N”, These two points contradict each other, Is the lookup field associated to account or Business Channel?
From your screenshot, I’m not find usefulness of the account entity, can you tell me what it’s work?
There is ‘Parent Business Channel’ in your screenshot, what is it used for?
If posiible, can you provide screenshot about forms for each entity.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Community site session details

how to filter link entity records using fetchXML.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

Featured topics

Product updates