You need to sign in to do that
Don't have an account?
Steven Houghtalen
How to perform a simple table join
I am hoping someone can help me with this. I want to perform a simple table join but I find the documenation very difficult to get to the right solution. Here are the 2 tables (custom objects):
Service Log (custom object)
ClientID Date of Service
24 12/16/16
34 12/1/16
15 12/20/16
Client (custom object)
ClientID Language
24 Spanish
12 English
34 French
15 Mandrin
I want the resulting table (list) to contain the language for every record in the Service Log. The list would have the followiong fields:
ClientID Date of Service Language
Hope someone can help me by showing me the needed query and perhaps point me to better documentation on how to perform the different types of table joins.
Thanks
Service Log (custom object)
ClientID Date of Service
24 12/16/16
34 12/1/16
15 12/20/16
Client (custom object)
ClientID Language
24 Spanish
12 English
34 French
15 Mandrin
I want the resulting table (list) to contain the language for every record in the Service Log. The list would have the followiong fields:
ClientID Date of Service Language
Hope someone can help me by showing me the needed query and perhaps point me to better documentation on how to perform the different types of table joins.
Thanks
All Answers
Your clients are not all users probably.
If your object Client__c doesn't contain a field Language, you can look for all the relationships and with User perhaps.
Indirectly, you can access the language of the sales rep who is responsible of many clients (territories and roles).
Alain