Hello, I have a custom object with three lookup fields, one to User one to Contact and one to Account. I'm executing the following query but it complains about the relationship in getting the name from the User object. If I exclude User__r.Name from the query It returns the Contact and Account Names OK. Any help would be appreciated.

SELECT User__r.Name, Number_Tickets_Requested__c, Contact__r.Name, Account__r.Name FROM SFL1_Ticket_Req__c
 

Hello, I have a custom object with three lookup fields, one to User one to Contact and one to Account. I'm executing the following query but it complains about the relationship in getting the name from the User object. If I exclude User__r.Name from the query It returns the Contact and Account Names OK. Any help would be appreciated.

SELECT User__r.Name, Number_Tickets_Requested__c, Contact__r.Name, Account__r.Name FROM SFL1_Ticket_Req__c