Transaction entry problem (VB.NET+SQL Server 2K)

[sbasak]

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!

[sbasak]

I thought of a solution. If I make the primary key column as GUID, then probably the concurrency problem wouldn't be there as there will be very rare chance of generating duplicate keys between disconnected instances of datasets.

Any idea??