Thread: Any suggestions
View Single Post
  #1  
Old March 22nd, 2010, 04:43 PM posted to microsoft.public.access.tablesdbdesign
bs base
external usenet poster
 
Posts: 1
Default Any suggestions

I am fairly new to Access and am designing a new database. I retreive all of
the data from various Excel worksheets. I have 5 tables that I will update
from excel on a monthly basis then display the information in forms and
reports. And, 1 tablet that I will add information directly into the database
in a seperate form.

All of the tables have information pertaining to the parts that we make. So,
I have made an additional table that lists just the part numbers and use that
in creating relationships between the other tables, but am not sure that I
need to do that. The 5 tables do not all contain the same part numbers. One
table may have 3,000 parts and another table may have 2,500 parts and only
300 matching parts.

Am I on the right track to relate these tables or do I need to approach it
another way? We add new parts numbers on a regular basis so I am seeing that
I might run into some major issues with the parts table.