Good Evening All:

I have the code below that is designed to create child records (Assigned_Address__c) on Turf__c when the Turf__c record is created. I am getting the dreaded System.LimitException: Too many SOQL queries: 101error message when I attempt to create a Turf__c record. I thought I had written this to properly handle the creation of child records. Depending on the conditions, the number of child records created at one time would be between 10 and 500. Do I need to explore another option than this?

As always, your help is much appreciated.

Thanks!

Hampton

trigger NewAddressAssignment on Turf__c (after insert) {

Set<String> releaseName = new Set<String>();
for (Turf__c newDoor: Trigger.new) {
     releaseName.add(newDoor.Name);

Map<String, Address__c> addressMap = new Map<String, Address__c>();
for(Address__c address1 : [Select ID, Name, Unparsed_Address__c, Release__c, Video_Qualification__c from Address__c where Release__c in : releaseName]){
    addressMap.put(address1.Release__c, address1);
    
List<Turf__c> turfList = [Select ID, Name, New_Resweep__c from Turf__c where Name in : releaseName and New_Resweep__c = 'New'];

List<Assigned_Address__c> newAssignment = new List<Assigned_Address__c>();
    for(Turf__c newRelease : turfList) {
    Assigned_Address__c a = new Assigned_Address__c();	
    a.Address__c = addressMap.get(newRelease.Name).Unparsed_Address__c;
    a.Turf__c = newRelease.ID;
    a.Address_ID__c = addressmap.get(newRelease.Name).ID;
    newAssignment.add(a);
    }
insert newAssignment;       
    }
}
}