You need to sign in to do that
Don't have an account?
Rob P12
What's wrong with this query, I'm trying to reference Child relationship data
I am trying to get to the Child Relationship Data.
In SF Explorer:
QMB_Cost_Center__c
Child Relationships:
R00n0000001OrWrEAK
Child Fields:
Budget_Actual__c
Child Object: QMB_Budget__c
Related Field: QMB_Cost_Center__c
Relationship Name: R00n0000001OrWrEAK
QMB_Cost_Center__c
Child Relationships:
R00n0000001OrWrEAK
Child Fields:
Budget_Actual__c
Child Object: QMB_Budget__c
Related Field: QMB_Cost_Center__c
Relationship Name: R00n0000001OrWrEAK
trigger getBudgetData on QMB_Cost_Center__c (before insert) {
For (QMB_Cost_Center__c cc : [Select id, name, (Select Budget_Actual__c from R00n60000001OrWrEAK)
from QMB_Cost_Center__c]){
}
}
For (QMB_Cost_Center__c cc : [Select id, name, (Select Budget_Actual__c from R00n60000001OrWrEAK)
from QMB_Cost_Center__c]){
}
}
Error: Compile Error: Didn't understand relationship 'R00n60000001OrWrEAK' in FROM part of query call. 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. at line 2 column 32
Tried:
R00N0000001OrWrEAK__c
R00N0000001OrWrEAK__r
QMB_Budget__c
QMB_Budget__r
R00N0000001OrWrEAK__r
QMB_Budget__c
QMB_Budget__r
Code: HTH