[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

MS Access: Table development

In the table "tblToolName" as it suggests will be a list of tool names. We have many tools with the same name such as 6" calipers we currently have about 50 but each has a different serial number.

Do I really need this table? Should I put this field in the table "tblTools" or is it better to leave it like it is??

Measuring-Instruments-3-4-21-11.mdb
0
James Coats
Asked:
James Coats
  • 4
1 Solution
 
gavsmithCommented:
No you do not need the extra table.

Regards
Gav
0
 
gavsmithCommented:
Try to think about table relationships, one to many, many to many, one to one. One to one is what you would be creating which most of the time are not required... although there may be times when it's usefull! (see the comments on one to one relations on this page: http://msdn.microsoft.com/en-us/library/s780ea06(v=vs.71).aspx)
0
 
gavsmithCommented:
Hold on, I may have been getting this wrong (I had to make assumptions based on the fact there is no sample data and your comment above). If the relationship is:

tblTools.Serial#->tblToolName.ToolName_ID

(which i first assumed) then that would be a one-to-one relationship, however:

tblTools.Tool_Name_FID->tblToolName.ToolName_ID

then it can be one-to-many.

So you could have:

tblToolNames:
ToolName_ID      Tool_Name
1                         6" Caliper

tblTools:
Tool_ID   Tool_Name_FID  Serial_#
1             1                         ABC001
2             1                         ABC002
3             1                         ABC003

etc. That would make the table worth while.

Sorry about the confusion
Gav
0
 
James CoatsAuthor Commented:
Thank you for that update I will change it back as I am going to invest a lot of time in this effort.
0
 
gavsmithCommented:
In that case... my 2 cents, I personally would have had a table with a more generic name, say called tblToolType (instead of tblToolName), then you can move other related info such as the 'Type_of_device' field into the one table:

tblToolType
ToolType_ID   Tool_Type   Tool_Name
1                     Measuring  6" Caliper

tblTools
Tool_ID  Tool_Type    Serial_#
1            1                  ABC001
2            1                  ABC002

Hope that helps
Gav
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now