I am trying to create a database for my machine shop and can't get the design down. Can anyone help? What I am trying to do is:
1- Have a tooling number which has a tool type (Drill, Mill, ect.), Tool size (1/2", 3", 3.875", ect.), and a Tool discription (3/8" HSS Drill, 1/2" Carbide Endmill, ect.)
2- Have a tool build up for each tooling number which would include multiple parts that would have a Manufacturer, Description, Part number and Qty (for each part ie.: Kennametal - 50 taper tool holder - CV50TG100350 - 1 ect.)
3- Also there are Perishable parts that would also have a manufacture,r description, part number, grade, and qty which could also have multiple entries per tool number.
4- Finally there are Replacement parts as above would have manufacturer, description, part number, and qty which could have multiple enteries per tool number.
I also want to have a form to enter information, also be able to enter multiple components per component fields.
I would like to be able to query a tool number by tool number or by tool type, or by tool description, or by size, or by general size (like i am looking for a boring bar between 1" and 2").
If someone could help me I would greatly appriciate it.
Thanks,
JD