Too many SOQL queries: 101 is a error u receive when u cross the maximum limit of 100 queries execution . This is a governer limit forced by salesforce to avoid monoploy in multitinnet environment and should not be crossed.
U should propably check for any "select" queries inside for loop in any other programs also.
Your trigger seems to be going into resursive mode. Try putting a static variable to stop the recursive action. You can find this on SFDC help or also check if there is no other trigger being fired for related objects.
I am not sure why you are getting error but your code could be optimized to the below -
Too many SOQL queries: 101 is a error u receive when u cross the maximum limit of 100 queries execution . This is a governer limit forced by salesforce to avoid monoploy in multitinnet environment and should not be crossed.
U should propably check for any "select" queries inside for loop in any other programs also.
Your trigger seems to be going into resursive mode. Try putting a static variable to stop the recursive action. You can find this on SFDC help or also check if there is no other trigger being fired for related objects.