Query to Automattically create Pack Price based upon the products that make up the pack

[lateral]

Hi Guys

 

I have a number of packs defined that have 20 - 30 products in them.

 

When I change the price of any of the individual products, I need to manually change the pack price.....

 

I have Googled but cannot find a solution to this.

 

Can somebody please help me and provide me with an SQL query that I can run that will update the pack price based upon the total of the individual price prices???

 

Thanks for your help.

 

Regards

Greg