Hi, I have a list of item,when

[cherrielwy]

Hi,

I have a list of item,when a customer order some item from the list,i will fill in the quantity for the item the the customer need.each customer will have difference ID every time they made order.The list of item will be change when i have new item.Any suggestion for me to design my database. I need to have a report also for each ID about what the item they order and the quantity. Thank You.

 

[KenReay]

Hi

Well you need a minimum of three tables

tblCustomer
CustomerId (Prime Key)
CustomerName
CustomerAddress1
CustomerAddress2
...etc

TblOrderHeader
OrderNo (primeKey)
CustomerId
OrderDate
...etc

tblOrderItems
OrderNo )
OrderItem ) Prime key
OrderQty
Price
...etc



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK