I have 3 data tables to update database

* `Invoice` table, primary key is `InvoiceNo`
* `InvoiceProduct` table, primary key is `InvoiceProductNo` and foreign key `InvoiceNo`
* `InvoiceProductExp` table, primary key is `InvoiceProductExpNo` and foreign keys are `InvoiceNo` and `InvoiceProductNo`

Facts:

* One `InvoiceNo` has many `InvoiceProductNo`
* one `InvoiceProductNo` has many `InvoiceProductExpNo`

3 Data Tables data entry would be for example is 

```
Invoice (InvoiceNo,...)
(0001,...)

InvoiceProduct (InvoiceProductNo, InvoiceNo)
(1,0001,...)
(2,0001,...)

InvoiceProductExp (InvoiceProductExpNo,InvoiceProductNo,InvoiceNo)
(1,1,0001,...) 
(2,1,0001,...)
(3,2,0001,...)
(4,2,0001,...)

```

The problem is I liked to use SQL Server generated `Identity` column for all primary keys of 3 tables

How can I prepare for `insert` statements?

```
Insert Into InvoiceProductExp values (auto_number, ?, ?)

```

How can I get `InvoiceProductNo` to insert into `InvoiceProductExp` table since `InvoiceProductNo` is auto number?