On Grid Dialog Add Save in a different table

Hi ;

I want on grid CRUD dialog actions using the toolbar or row double click to act on a different table instead of the underlying grid table . My scenario is the data grid is based on products table   with following cols : productId , ProductName and CategoryID

When I double click a row I want the dialog to display the selected product and a column orderQty from orders table , on click save or add I want to post or insert a new row in orders table for the currently selected  productId and the associated   orderQty


1 Reply

JP Jeevakanth Palaniappan Syncfusion Team November 15, 2021 02:44 PM UTC

Hi Hannu, 

Greetings from Syncfusion support. 

We have validated your query and based on your scenario, we suggest you to use the foreignkey column feature of the grid. Please refer the below documentation for your reference. 

Also if you want to customize the edit dialog, then you can use the dialog template feature of the grid. 

Please get back to us if you have any other queries. 

Regards, 
Jeevakanth SP. 


Loader.
Up arrow icon