订单表与订单详情表的数据插入

[RabbitVi]

接到一个任务，有这样两张表：
Orders：
CREATE TABLE [dbo].[Orders](
[OrderID] [int] NOT NULL,
[CustomerID] [nvarchar](5) NULL,
[EmployeeID] [int] NULL,
[OrderDate] [datetime] NULL,
[RequiredDate] [datetime] NULL,
[ShippedDate] [datetime] NULL,
[ShipVia] [int] NULL,
[Freight] [money] NULL,
[ShipName] [nvarchar](40) NULL,
[ShipAddress] [nvarchar](60) NULL,
[ShipCity] [nvarchar](15) NULL,
[ShipRegion] [nvarchar](15) NULL,
[ShipPostalCode] [nvarchar](10) NULL,
[ShipCountry] [nvarchar](15) NULL,
CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED
(
[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

OrderDetails：
CREATE TABLE [dbo].[Order Details](
[OrderID] [int] IDENTITY(1,1) NOT NULL,
[ProductID] [int] NOT NULL,
[UnitPrice] [decimal](18, 3) NOT NULL,
[Quantity] [smallint] NOT NULL,
[Discount] [real] NOT NULL,
CONSTRAINT [PK_Order Details] PRIMARY KEY CLUSTERED
(
[OrderID] ASC,
[ProductID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


我该怎么样才能实现一个订单下多个产品的数据插入呢？
难度在于：订单表的ID号不是自增的，可是订单详情表的ID号确为自增，又因为订单详情表的ID要根据订单ID来取，所以不知道怎么来实现一个订单下多个产品的数据插入。

[开着拖拉机泡妞]

能否举例说明你的问题？

[鐵蛋]

主从表的问题，同步主从表的对应字段你不需要在SQL语句里面做，这个对应放在前端同步，每次从表新增的时候把主表的OrderID字段赋值给从表就ok了，可能主表这时还没提交，总之把主表数据集的对应字段赋值给从表数据集