Multi Level Many To Many Relations

HI ,

Can someone help me how to handle Multi level Many to Many relationship. Do you have some example reference already discussed. I could not able to use a proper "search string" to query forum.

I have attached image to illustrate the problem. I am sure this is frequently appear challenge in every project.


I have many to many relationship between (Product and group) and (Group and Items). Now i need to get all the items (Unique) assigned to Product thru groups.

Thanks in advance,


HI All,

I am able to figured it out using "through" option.

Thanks to all.