I have a custom object
Obj__c where I have created a custom lookup field to Account.
In the Account layout I have an
Obj__c related list showing the
Obj__c records related to a particular Account.
What I wish to achieve is to hide certain records in the related list.
- if the Account status is set to Active hide all
Obj__c records with status Closed
- if the Account status is set to Inactive hide all
Obj__c records with status Open.
Is it possible to hide records in related list based on the status of the parent record and how it can be achieved?