There is a common requirement to filter subgrid based on the lookup field, but there is no easy way to implement it without writing code. In this post I am going to discuss a quick workaround to implement this requirement. Let’s see how we can implement this.
Requirement: We want to show marketing list for accounts in contact form based on the account lookup.
Solution: We can implement this requirement with the help of the quick view form using following steps:
1. Open default solutions by Navigating to Settings->Customizations->Customize the Systems or create your custom solution and add Account and Contact entity to your custom solution.
2. Navigate to Forms under Account entity
3. Create New Quick View form and change form name “AccountMarketingListQuickViewForm” using Form Property button on the top
4. Click on Insert and add a subgrid and set following options
Now open contact having Hewlett Packard in company name lookup and you will be able to see related marketing list like below
Hope it will help someone !!