If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|