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.

1 Answer 1


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

Name = Account__r.minInvoiceNumber__c
  • 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
    Commented Aug 25, 2017 at 17:36
  • Yes, @DerekF. I would like to say a standard relationship. Like Account and Contacts, for example.
    – m Peixoto
    Commented Aug 25, 2017 at 18:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .