+ Start a Discussion
Rakesh SRakesh S 

Retrieve parent object fields if it is lookup relationship

Hi All,

I have a Patient__c object in which Referring_Physician__c is lookup field. So now i can retrieve physician field using like..{!Patient__c.Referring_Physician__c}.

But now i want to retrieve physician__c object fileds.  like Primary_Phone__c filed.
Can i do that ?. Please help me. I am using this in Email template where am passing Patient__c object details while sending an email.

I tried many ways but it is not working(not displaying field values in email template).
{!Patient__r.Referring_Physician__c.Phone_Primary__c}
{!Patient__r.Referring_Physician__r.Phone_Primary__c}
{!Referring_Physician__c.Phone_Primary__c}
{!Referring_Physician__r.Phone_Primary__c}

Thank you.
Rakesh.S