I'm having a typical OrderForm with Order details in a datagridview like in the Northwind DB.
I create a dataset containing Order and Orderdetails.
I drag detils from Order and a gridviw from orderdetails under order.
When I run it, it works fine until I create a new order and enters order details. The temporary orderno -1 creates a foreign key error in orderdetails when I save. I thought the table adapter would take care of this for me?