How many tables would be needed...

[aerofuego]

How many tables would I need for the following:

Order#
customer
date/time order received
date/time order due
courier (the order might be shipped via two or more different couriers)
dept (the order might be sent to three different depts.)

the order will be for making photocopies of different sizes
and different width

If I need to provide more information, let me know.
Any help would be appreciated

Thanks.

 

[GohDiamond]

one way may be as below:

Customer Table
Order Table
Departments Table
Couriers Table

Looks like 4

Add 1 more for each <<Many to Many relationship>>

If that doesn't give you a starting point you'll need to give some more details about how the data should relate. See the Northwind Database for a working example.

Happy "Access"ing

Goh

 

[aerofuego]

I'll try your suggestion

I'll give it a try and see how it works out.

I might have more questions but for now let try this out first.

Thank you for the reply.