Thanks.

Basically what I have here is a simple trigger (trigger and test class below...it passes 100% with this test), that updates a custom lookup field on opp object called Primary_Contact__c (a lookup field to contact object).

The trigger just populates an opp' Primary Contact with the first contact created for the account the opp belongs to.  This is good enough.

Everything works, except when I got into my sandbox and do a test insert of 1000 new opps, I get an error that says there are "too many soql queries".

  ///Set PrimaryOppContact

///trigger on opp object   

 if (Trigger.isInsert && Trigger.isBefore) {        
        for (Opportunity o : Trigger.new) { 
        List<Contact> contactList = [select Id from Contact where AccountId = :o.AccountId];        
        o.Primary_Contact__c = contactList[0].Id;                                    
        }
    }


///test method
    static testMethod void testPrimaryOppContact() {
        Account account = new Account();
        account.Name = 'Test';
        insert account;
        
        Contact contact = new Contact();
        contact.FirstName = 'TestFirst';
        contact.LastName = 'TestLast';
        contact.Email = 'test@test.com';
        contact.AccountId = account.Id;
        insert contact;
        
        
        Opportunity opportunity = new Opportunity();
        opportunity.Name = 'Test';
        opportunity.StageName = 'Prospecting';
        opportunity.CloseDate = Date.today().addDays(1);
        opportunity.AccountId = account.Id;
        insert opportunity;
        Opportunity resultOppty = [Select Id, Primary_Contact__c from Opportunity where Id = :opportunity.Id ];
        
        System.assertEquals(contact.Id, resultOppty.Primary_Contact__c);

                                       
           
    }