We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Nested foreign key columns in grid

I have country and state columns in the grid. They are foreign keys from country and stateprovince table. 

How do I pass the particular row's countryid to the state datasource to filter those rows? Here is how it displays.

Your help is greatly appreciated.

Thank You,



1 Reply

TS Thavasianand Sankaranarayanan Syncfusion Team December 13, 2019 09:55 AM UTC

Hi Ameet, 
Thanks for contacting Syncfusion support. 
By default, while using foreignKey column then it map(filter) the grid data source(CustomerID) with foreignkey data source(CustomerID) based on the mapping value(VINET) and return the result('Pual Henriot'). Please refer the below sample and help documentation for more information. 
We could not able to view the attached image that you are provided in previous update. If the above does not meet your requirement then share more information about your query , table structure  and local/remote data binding etc., which helps us to analyze further and provide a better solution as soon as possible. 
Thavasianand S.  

Live Chat Icon For mobile
Up arrow icon