+ Start a Discussion
arasuarasu 

Formula field and lookup field issue

Hi,
 
I am trying to create the following formula field in a custom object named Product. I want the product name to be generated dynamically from the Brand Name and denomination field selected for the product. Brand is a lookup field in Product Obejct. When I save the following formula, it says "Error: Field Brand__r does not exist. Check spelling."
 
Formula:
 
Brand__r.Name & "-" &    TEXT(Denomination__c)
 
If I use Brand__c & "-" &    TEXT(Denomination__c) , the the 15-digit Brand ID is displayed instead of name.
 
Please let me know is there is any workaorund for this.
 
Thanks for your help.
 
Ambili
MattLMattL
You need to issue another query, and then pull the Name from that.

New query:
query = "Select Name__c from SFDC_Product__c where Id='"+Brand__c+"'";