Many-to-Many relationship

[Laura]

I am new to using rad controls and I am in the process of creating a simple front end to a database. The tables in the database are set up in such a way that I have a many-to-many relationship with an intermediate table. An example is I have a vendor table and a contact table and an intermediate table called vendor-contact which has the vendor id and contact id and it links the other 2 tables. I am using a radgrid control and am having difficulty setting up the hierarchy with the vendor being the master table and the contacts being the detail table. Is it possible to use the hierarchy in radgrid with a many-to-many relationship? If so, does someone have a sample of the select query I could use for the details table?


Also, on a different question, I would like to use the tooltip so that when a user hovers over the vendor name, all the data from the vendor table populates in the tooltip. Is it possible to combine the radgrid and the tooltip?

Thanks in advance,
Laura

[Rosen]

Hi Laura,

I have attached a small project which demonstrates a simple implementation of how to create a hierarchal RadGrid in described case. Please give it a try and see if this helps.

Kind regards,
Rosen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Laura]

Rosen,

Thank you so much for the sample you provided. It really helped in my understanding of how the tooltip works in the grid. I got my application working thanks to your help.

Laura

[Tomasz]

I use generic hierarchy gryd with many-to-many relationship.
Works fine until I want to use insert generic popup to one of the related tables in a second level of hierarchy.
Just doesn't work.
What am I doing wrong?
Can I do that at all? or maybe I should use another page to do that?
Thanks in advance.

Tom