Help!

[Guest]

Hi

I am trying to design a database for a small business. They have customers,
orders and obviously products.

Could you give me some guidelines as to where to start with this - I am
struggling with one order having possibly multiple products etc.

Thanks

S x

 

[Allen Browne]

When you install Access (or Office), it installs a sample database named
Northwind. Open this database, and see how it works. It covers customers,
products, and orders.

In Northwind, choose Relationships on the Tools menu to see what the tables
are, and how they relate to each other. One order can contain many line
items (for different products), so you will see the Orders table (for the
order header) and the OrderDetails table (where the line items go.)

That's the only way to design this kind of thing.

 

[John W. Vinson]

Could you give me some guidelines as to where to start with this - I am
struggling with one order having possibly multiple products etc.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

and the Northwind sample database, as suggested...

John W. Vinson [MVP]