I have master/detail tables for invoices and invoice items.
I have tried to implement Master/Detail Add but it is failing with Invalid Key Value, I think in the detail record insert.
I have seen some posts referring to not using autoincrement for the Master key value can be an issue. Does this mean you have to use an autoincrement for the Master table primary key or can it be accomplished. I have tried creating the key value in the Master table Row_Inserting event, saving it to a Session variable and using it in Detail Row_Inserting but I get the same error?
Can you confirm that it is mandatory to use an auto increment key in the Master table?