I think so

Each table has its own data.

The customer details will be in the customer table.

Order details in the order table etc...

Each table has its own primary key.

Tables are linked via...

Customer information is in the customwe table

One customer can have many orders

lol i don't know i am learning normalisation.

will i be able to relate the order table with the customer by customer ID

so whatam i looking for

you need to store it with order so that they know whos order it is

Customer

Customer Forename

Customer Surname

Street

Town

Postcode

Email

Category

and the order table will have this detail, so that they can dispach it to...

Lynn Pettis (3/27/2012)

Think about orders you have placed with a company. Right now I am just trying to help you look...

what else am i suppose to look for

one order has many stock

-----------

Stock ID

one customer can have many orders

i had this before is this right

orders belong to a customer

am sure its the customer table that links to the order table

but maybe we can create another table