record of customers and their (multiple) orders.

[Neil_1li]

Hi all, I'm trying to create my first database and I'm a bit stuck.



I want to keep a record of customers and their (multiple) orders.

For example:

Mrs A places an order for £10 in week 12 then an order for £40 in week 14

Mr B places an order for £5 in week 6 then an order for £15 in week 22

So, fields I require are: Forename, Surname, Address, phone no, and then the dates and amounts for their orders. This the part I'm suck on.

[pbaldy]

Your design would include a customer table with the name and address data related to the customer, and it should probably include a customer number to ensure uniqueness. Then you would also have a "sales" table to record the information related to each sale, and one of the fields in that table would be the customer number from the other table. If a customer can buy multiple products, you would have a further "sales detail" table to record the item, quantity and price, where each product purchased was a separate record. You never want fields like product1, product2.