Relation problems

I'm creating a program where customers can by many products. He is asked to fill customers form and after that he can make orders. Basically, i have a tblOrder with OrderID(unique) and i want to create another tblOrder2, let's say customer wants to buy two products, he'll be alright with purchasing first product and what goes next i'm not sure... i'm kind of stuck.. i know it's quite easy to do, but can some1 plz explain how exactly is it done...

Of coz i can create a table where you will have 5 fields for diffirent products, but that will be a waste of space if customer decides to purchase only one product...

What I would like you to do is look at the sample database, that comes with Access, Northwind. It is an order system, just like you described, that allow customer to place multiple orders on one order. It uses a link table bewteen orders and inventory items.

Look at that and the ask any other questions that you may have.

S-

by the way, that's what i did...

Thanks for that anyways,

Do you have anyquestions about Northwind DB, and the table OrderDetails?

S-

Thanks for your help baxter... the Northwind database is too complicated for me, but i've done the same Order relation...

Have a look at the relation(i attached it!)

Do u mind if i send u my database, so u can have a look at it? I dont' wanna attach it.. if you could give me your email address where to send,