Access line items

[webguy]

I am trying to add line item details to a Access DB. How
do i enter records on more than 1 line without creating a new record?
Thanks

[andi_g69]

Correct me if I am not getting the point :-)
Usually you should have the following structure:

tblItem (ItemNo, ItemDate, ....)

tblLineItem (LineItemNo, ItemNo,....)

the LineItem table references the Item table by ItemNo. In your Item table you have one record per Item, in the LineItem table you have 1 to n records per Item. One representing each LineItem.

[webguy]

Yes i have a customer table and a
order detail table. In the detail table
1 order could have 1 line or upto 50
lines. Such as:
Item#, Item Description, Quanity etc...
1.
2.
3.
4.
etc...
Thanks for your reply

[andi_g69]

So you do not have an order table?

This also means your data model is not normalized properly.

Generally speaking an order DB looks like this:

Customers (CustNo, CustName,...)

Products (ProductNo, ProductName,...)

Orders (OrderNo, CustNo, OrderDate,...)

OrderLine (OrderNo, LineNo, ProductNo, Qty, ....)

With this approach you store the relevant Order data once per order and one record per order line.