I am having a problem inserting data.

I have two SQL Server tables

Trans -> TranNo (auto number), CustNo, StoreNo etc.
TransDetail -> TranNo (foreign key from Trans.TranNo), TranDetailNo (auto number), ProdCode, Quantity

I have made a master-detail form in VB.NET using data form wizard.

The problems are:

1. I can't enter data in the two tables at same time. First I need to save the master data and then only I can enter children data (unlike in D2K Forms).

2. Since Trans.TranNo is an identity (auto number) field, if more than one instances of same form is used to insert date, concurrency problem arises.

Can anyone throw any light?

Lots of thanx in advance!