I am trying to create a checkbox formula field on Account object.
This is to be checked based on the record type and isactive field in another object (say Rel__c Object). These two objects have a master-detail field on Rel__c Object.
If there is a record with IsActive=true and record type = 'XYZ' or record type ='ABC' on Rel object, then the check box on Account should be Checked.
When I create a formula field with return type checkbox , I dont see the option to select the Rel__c object in the formula editor.