TSThavasianand Sankaranarayanan Syncfusion Team December 13, 2019 04:55 AM
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.