function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Formula field and lookup field issue

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."
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.
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+"'";