pricing issue

Hi SD Gurus,

I have a complex scenario in pricing and need you inputs please.

Suppose, I have 3 items in the sales order mat1, mat2, mat3.

I have material groups numbers for all mat2 and mat3 and Based on the material group numbers of the mat2 and mat3 like which is highest it should consider that mat group number and accordingly we have to write the condition table and determine the pricing for mat1.

Please through some ideas.

Thanks

Sharath.