Your question is not clear. But based on my guess I give you this answer.
Actually you need 3 tables(Just sample & add more fields you want). You should separate the items details. One to many.
TblCustomer
-------------
CustomerID
CustomerName
TblOrderMaster
-------------
OrderID
OrderDate
CustomerID
TblOrderDetails
-------------
OrderID
Items
Qty
So the data will be like this
Customer Details
CustomerID CustomerName
----------------------------------------------------
1 Customer 1
2 Customer 2
Order Master
OrderID OrderDate CustomerID
----------------------------------------------------
101 01-Nov-2011 1
102 02-Nov-2011 1
103 03-Nov-2011 1
Order Details
OrderID Items Qty
----------------------------------------------------
101 BACON 10
101 PIZZA 5
102 BACON 5
102 PIZZA 15
102 DIET COKE 10
103 PIZZA 5
Here the
Order
101 contains 2 items, 102 contains 3 items.
Use
this[
^] for Identity insert.