How do find foreign key constraint in dataTable editor.

priyankaverma123

I have Two Table-
table1-Sell Order
SellOrderID
Details

table2-Inventory
ItemID
Description
SellOrderID

now i have to inserted record on table2 with last generated SellOrderId on table1
how could i add items simultaneously in two tables with the use of DataTables

allan

Hi,

I don't appear to have a record of an Editor license for your account (trial or purchased). Could you confirm which account you made the purchase under or started your trial with, so I can update my records please?

Regarding your question, you would need to run a custom SQL command to insert into a second table if it isn't joined using the leftJoin method.

Thanks,
Allan