How to create a relational database

H

Help Me Please

I have 19 products which will each have a separate table each as within each
product table will be between 13,000 and 2 customers. The customers could
appear in all 19 or just in 1. I want 1 main table where 15,000 names will
appear so that I only have the customers name stored once. I also would like
there to be a key so that my boss can see where each customer is, so he can
see if they appear on 1 or 19 tables. The project seems like it is never
going to end and I don’t no where to go from here. I have no support in the
office and am left alone to do this task.
 
T

Tom Wickerath

Whoa! Your first two sentences indicate a very improper database design.
You do not want to store each product in a separate table. All products
should be stored in one table. You do not want to store customer names in the
same table that product information is stored in. A table should represent a
single subject.
I want 1 main table where 15,000 names will appear so that
I only have the customers name stored once.
Click to expand...
This part of your message indicates correct database design.

You should spend some time gaining an understanding of database design and
normalization before attempting to build something in Access (or any RDBMS
software for that matter). Here are some links to get you started. Don't
underestimate the importance of gaining a good understanding of database
design. Brew a good pot of tea or coffee and enjoy reading!

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

http://www.datadynamicsnw.com/accesssig/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208

http://support.microsoft.com/?id=289533

Also recommended: Find the copy of Northwind.mdb that is probably already
installed on your hard drive. Study the relationships between the various
tables (Tools > Relationships...)

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have 19 products which will each have a separate table each as within each
product table will be between 13,000 and 2 customers. The customers could
appear in all 19 or just in 1. I want 1 main table where 15,000 names will
appear so that I only have the customers name stored once. I also would like
there to be a key so that my boss can see where each customer is, so he can
see if they appear on 1 or 19 tables. The project seems like it is never
going to end and I don’t no where to go from here. I have no support in the
office and am left alone to do this task.
 
Top