Child Relationship Query Not Working

Question

I have a trigger that I am trying to update the custom object (Share_Reference__c) within the Account object. For some reason my query in List accounts isn't working, saying that it didn't understand the relationship 'Share_References__r'. Any ideas? It should be the child object, like I have it. Thanks!

Trigger

        trigger UpdateIsShareRef on Share_Reference__c (after insert, after update, after delete, after undelete) {

    Set<ID> accountIDs = new set<ID>();
    List<Share_Reference__c> records;

    If  (trigger.isDelete) {
        records = trigger.old;
    } else {
        records = trigger.new;
    }

    for (Share_Reference__c record : records) {
        accountIds.add(record.Account);
    }

    **List<Account> accounts = [SELECT Id, is_Share_Ref_USAT__c, is_Share_Ref_Digital__c, (SELECT id, SalesTeam__c FROM Share_References__r) FROM Account WHERE ID IN :accountIds];**

    For (Account act : accounts){
        act.is_Share_Ref_USAT__c = false;
        act.is_Share_Ref_Digital__c = false;

        for (Share_Reference__c ref : act.Share_References__r){

            if (ref.SalesTeam__c == 'USAT Integrated Brand Sales'){
                act.is_Share_Ref_USAT__c = true;
            }

            if (ref.SalesTeam__c == 'Digital Sales'){
                act.is_Share_Ref_Digital__c = true;
            }
        }

        update accounts;
    }
}

Answer 1

Each relationship has a standard or custom relationship name, except for a few exceptions. Any time a relationship is available, you can query it in your sub-query. Please note that the name of the relationship may not reflect the name of the object, the field that created the relationship, or anything else.

You'll need to specifically look at the relationship to figure out what the correct name should be. Go to the Share_Reference__c object, find your Lookup or Master-Detail field, and click on the field's label (Setup > Create > Objects > Share Reference > Custom Fields and Relationships). In the lower-right corner of the field's detail page will be a field called "Child Relationship Name." Since it's custom, you will append the __r, even though it won't show in the relationship name field.

Answer 2

*(SELECT id, SalesTeam__c FROM Account.Share_References__r) FROM Account .

Use Account.Share_References__r .....in the Query ....