Hello,

I have a master table and details table and set primary key foreign key relationship with master and details table

Now from vb.net, i use begin trans and start inserting data,

I have two insert statements, one to master and another to detail

the detail table insertion of row depends on the master table row updated just above.

When inserting the detail table row, it pops up with a foreign key error

if i wont use begin trans, all data insert properly to master and detail table.

how can we overcome this issue.

Database : SQl Server

thankzzzzzzzz