Filtering values in grid foreign key column based on another column's value

[Lee]

Hi,

I have a grid where amongst other columns, I have two columns which are related - in the first column I select from a list of available options and based on the value selected here, I want to apply a filter to a foreign key column elsewhere in the grid.

So for example if I have a column for "Company ID" with values [1, 2, 3, 4,5] and an FK column "Category", the values bound to the "Category" column are ID/Text pairs for all possible categories, but I'd like to filter that down based on a 3rd "CompanyID" value.

It seems that no matter how I configure the FK column, the underlying data source only ever has the ID/Text values so any attempt at filtering it down based on the CompanyID column doesn't work. Even if my bound values/remote data source returns objects with the required fields for filtering, they get dropped when the FK dropdown list's data source is created.

Is something this even possible to achieve with the grid? If so any pointers would be much appreciated.

[Eyup]

Hi Lee,

 

Thank you for writing to us.

If you try to change the data of the FK column's dropdown in edit mode, it would be better if you use a Custom Editor column instead of a ForeignKey column:
https://demos.telerik.com/aspnet-mvc/grid/editing-custom

And then you can use additional data for the Read method to bind the dropdown:
https://www.telerik.com/forums/pass-additional-parameters-to-read-ajax-datasource-method---mvc

Feel free to give this approach a try and let me know how it goes for you.

 

Regards,
Eyup
Progress Telerik