Table with foreign key

[Rafael]

TbCity: idCity,name,idState
TbState:idState,name

In RadGrid I want to view and search the following fields through the TbCity : TbCity.name and TbState.name.
How do I proceed?Thanks.. 

[Pavlina]

Hello,

To achieve your goal you could try using a hidden GridBoundColumn which is bound to the text values related and displayed in the foreign key grid column. Then on filtering operation triggered for the foreign key column, you need to cancel the default operation and execute it against the hidden GridBoundColumn that contains the actual text values.

For reference you can review the implementation from this help article. I hope this approach is doable in your case.

Regards,
Pavlina
the Telerik team