I am stumped! On the Account object I have a lookup field to reference other Accounts who may be assisting that Account (Subcontractors, Accountants, etc.)
I also have a Custom object which has a lookup to the Account
Object.
There is a formula field on the Custom object which is attempting to return the Account's subcontractor, accountant, etc.
Account__r.Accountant_c
brings back just the ID
, I need the name.
Account__r.Accountant__r.Name
bring back nothing, no name.
Guys I am STUMPED. What am I doing wrong here?