I want to create a checkbox formula on a child object that checks if a field matches a field on the parent object.

The relationship between the two is lookup.

I've tried

Name = Account.minInvoiceNumber__c

But I get the error

Check Syntax Error: Field Account does not exist. Check spelling.

Is this a standard relationship? I am assuming that no. If not, you should use __r:

Name = Account__r.minInvoiceNumber__c
| improve this answer | |
  • 1
    Even if the child object is a standard SObject, if the lookup to Account is a custom field (as opposed to a standard relationship field), you'd need to use the __r syntax. Still, +1 from me for taking the words out of my mouth (or rather, taking the keys from under my fingers). – Derek F Aug 25 '17 at 17:36
  • Yes, @DerekF. I would like to say a standard relationship. Like Account and Contacts, for example. – m Peixoto Aug 25 '17 at 18:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.