Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
2 related subgrids on one Form or how visualize a parent-child-grand-child relationship?
I have following simple requirement.
Let's assume there 3 entities
Relationships are as follows: A:B ==> 1:N
B:C ==> 1:N
This means C is grandchild of A.
Now I want to a Form for entity A which displays two subgrids (one for entity B and the other for entity C).
These subgrids should be dynamically. This means: Subgrid C should only display grandchild records of the selected child record in subgrid B. When I change the selected record in subgrid B then subgrid C should refresh.
How can such functionality be achieved? Thanks
Sorry - nobody had ever had such a requirement ?
I would try to find a different implementation for the business case, but if you're married to the idea of having grids you might be able to make it work.
First, you need to get an event for when the B record is selected in your subgrid. There's expanded functionality for this in 2015 and Online, I'm not sure what's available in 2013. Here's the details for 2015: msdn.microsoft.com/.../dn932126.aspx
I hope this helps with what you're looking for. If it's helpful, I'd appreciate if you would mark this as the verified answer.
Although I have used filtered lookups - using one lookup to determine the values available to choose in another lookup, many times what you are requesting is the auto fill of one subgrid based on another subgrid. Essentially causing the second subgrid to be refreshed dynamically where records are added or removed depending on what records are chosen in the first subgrid. Possibly a custom webpage could mange this but I do not believe it is possible out of the box due to the recursive nature of the request. The solution would have to go through all the C records that are related to the B records that are related to the A record and add them to the A record.
There are several developers that follow this forum, maybe one of them has a suggestion. I will ask the developers I work with for suggestions as well.
The following URL might be helpful:
Hi Alen, I just wrote a blogpost describing a clean non-coding alternative to solve your issue. Hope it helps you:
D365 Display Grandchildren in Subgrid View without Coding
Business Applications communities