+ Start a Discussion
JeffStevensJeffStevens 

Customer Signed by from contract

The contract has the CustomerSigned field that is the ID to a contact.  However in my SOQL - I can't seem to figure out the relationships, etc.

 

I have this...

 

ctrcList = [SELECT ContractNumber,
CustomerSignedId,
CustomerSignedId__r.name,
CustomerSignedDate
FROM Contract];

 

But I get the error "Didn't understand relationship 'CustomerSignedId__r'"

 

I'm trying to get the relationship info from the CustomerSignedId off of the contract. 

 

Any thoughts?

 

Thanks

Best Answer chosen by Admin (Salesforce Developers) 
chriscommunitychriscommunity

I think you only need CompanySigned.Name, since the field name is CompanySigned.  Let me know if that works for ya.

All Answers

chriscommunitychriscommunity

I think you only need CompanySigned.Name, since the field name is CompanySigned.  Let me know if that works for ya.

This was selected as the best answer
JeffStevensJeffStevens

Yes - that did work.  I thought I had tried that but must not have.  (Actually - it was CustomerSigned.Name and Email)

 

Thanks.