function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Josie FarrellJosie Farrell 

I want to know how to create a formula that can do a lookup to another object(s) that has the same field value as a filed in the current object?

I have a custom object call Sample Received that I want to do a lookup to the account releated to an order whoose number is entered into a field inthe Sample Received object called Original Order. Here is the formula that I am using but it always returns a blank value:
IF(  Original_Order__c = null, "" ,  Original_Order__r.Practitioner_AccountId__r.Name  )
AbhishekAbhishek (Salesforce Developers) 
Hi,

Can you check this post this might help you,

https://success.salesforce.com/answers?id=90630000000gynIAAQ

Thanks.
Josie FarrellJosie Farrell
Thanks, Abhishek but this is what I was doing. It seems like the proble is that the fields in the Original order are themselves lookup fields and not matter how I try, they keep coming up blank. If, like it says int his post, us look up the ID filed, it actaully works but I need the name field that can the be selected.