[Solved] Filter a dropdowncolumn selection based a a value in the row

[Barry]

I am pretty new to the Telerik stuff (and ASP.net)... but from what I've read and seen I think what I want to do is possible... I just can't seem to make it work... 

Here is what I'm working with.. wthin my database I have a table with company information on various companies that we do business with... I also have another table for people that is basically a list of all of the people that we do business with at the various companies.  These two tables are joined together on a 1 to many relationship based on companyid.  In the companies table is a column for the primary contact.. which holds the personId of the person from the people table that is the primary contact for that company (pretty basic stuff... nothing fancy here)

What I would like to do is have a grid that list all of the companies... within that grid have a couple of columns that lists the primary contact's name and email address... and when I edit the company record, in the edit template, have a drop down list that is filtered to just show the people from the person table that are affiliated with the company record that I am editing, then when I update it, have it update the person ID of the primary contact for the company, but in the grid, update the grid row to show the new person's name and email address... 

I am stuck on the best way to accomplish this.. I hope someone can help... 

Thanks in advance.

And I almost forgot... in the drop down list in the edit template, I would like to show the people's names rather than just a personID.. 

[Kostadin]

Hello Barry,

I suggest you to review the following live example where is demonstrated how you can achieve the desired scenario.

Kind regards,
Kostadin
the Telerik team