I have a custom object, Session, with 4 similar lookup fields that all look up to contacts. The fields are:
In the Query Editor, the following SOQL query works fine:
Select Id, Name, Teacher__r.Name From Cluster__c
Replacing Teacher__r with Teacher2__r gets the following error:
ERROR at Row:1:Column:18 Didn't understand relationship 'Teacher2__r' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
The same happens for Tutor1__r and Tutor2__r. I'm baffled. Is there some rule against having more than one lookup to the same kind of object? Is there some special syntax that needs to be used in such a case?