For a Pending or Active Partner (using the Partner Status field on the Account), we need to look at all of their “Active” (checkbox on the Solution/Accrediation object) related Solution/accreditation records.
If any of those records have the field “Direct” checked “True”, then the checkbox on the Account field Is Direct, should be checked “True”. This box would be checked to False if none of the Solutions records have Direct checked True.
How to achieve this, should we create any validation rule or workflow? It would be grateful if anyone solve my issue and i would appreciate. kindly solve my issue