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
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?