Hello there everyone!
So I'm in process of creating a new database for use at work that will manage and keep track of our tooling kits. i have a pretty good idea on what tables I'll need and how they're connected except for one thing.
basically the main table i want is my kitting table, 'tblKits'
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]tblKits[/TD]
[/TR]
[TR]
[TD]KitID[/TD]
[/TR]
[TR]
[TD]PartNumber_FK[/TD]
[/TR]
[TR]
[TD]Op[/TD]
[/TR]
[TR]
[TD]Shelf[/TD]
[/TR]
[TR]
[TD]Location[/TD]
[/TR]
</tbody>[/TABLE]
I'll then have a bunch of other tables that will hold different types of tooling and other parts needed for jobs, ex:
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]tblTooling[/TD]
[/TR]
[TR]
[TD]ToolingID[/TD]
[/TR]
[TR]
[TD]ToolingDescription[/TD]
[/TR]
[TR]
[TD]ToolingCode[/TD]
[/TR]
[TR]
[TD]ToolingDrawing/StockNumber[/TD]
[/TR]
[TR]
[TD]ToolingQuantity[/TD]
[/TR]
[TR]
[TD]ToolingNotes[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]tblFixtures[/TD]
[/TR]
[TR]
[TD]FixtureID[/TD]
[/TR]
[TR]
[TD]FixtureDescription[/TD]
[/TR]
[TR]
[TD]FixtureQuantity[/TD]
[/TR]
[TR]
[TD]FixtureDrawing/StockNumber[/TD]
[/TR]
[TR]
[TD]FixtureNotes[/TD]
[/TR]
</tbody>[/TABLE]
This is where I'm not sure what to do. So for every Kit, it'll have the part number, the Op number, the shelf, and location, and then a whole bunch of tooling, which could include a handful of tools, multiple fixtures, and many other parts.
What would be the best way of building each kit with all these tools? i was hoping there's a way that i only need to fill out one kit, but then able to tie in as many tools as i want per kit, for example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]KitID[/TD]
[TD]PartNumber_FK[/TD]
[TD]Op[/TD]
[TD]Shelf[/TD]
[TD]Location[/TD]
[TD]Tooling[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]107[/TD]
[TD]10[/TD]
[TD]1[/TD]
[TD]A-1[/TD]
[TD]Boring Bar
Turning Tool
Fixture
Etc...
[/TD]
[/TR]
</tbody>[/TABLE]
Is this possible? or will i need to basically fill out the same kit each time and tie each separate tool with it and then after maybe make a query that shows per each kit, all the tools associated with it?
Hoping this isn't too confusing lol any help would be greatly appreciated, cheers.
So I'm in process of creating a new database for use at work that will manage and keep track of our tooling kits. i have a pretty good idea on what tables I'll need and how they're connected except for one thing.
basically the main table i want is my kitting table, 'tblKits'
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]tblKits[/TD]
[/TR]
[TR]
[TD]KitID[/TD]
[/TR]
[TR]
[TD]PartNumber_FK[/TD]
[/TR]
[TR]
[TD]Op[/TD]
[/TR]
[TR]
[TD]Shelf[/TD]
[/TR]
[TR]
[TD]Location[/TD]
[/TR]
</tbody>[/TABLE]
I'll then have a bunch of other tables that will hold different types of tooling and other parts needed for jobs, ex:
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]tblTooling[/TD]
[/TR]
[TR]
[TD]ToolingID[/TD]
[/TR]
[TR]
[TD]ToolingDescription[/TD]
[/TR]
[TR]
[TD]ToolingCode[/TD]
[/TR]
[TR]
[TD]ToolingDrawing/StockNumber[/TD]
[/TR]
[TR]
[TD]ToolingQuantity[/TD]
[/TR]
[TR]
[TD]ToolingNotes[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]tblFixtures[/TD]
[/TR]
[TR]
[TD]FixtureID[/TD]
[/TR]
[TR]
[TD]FixtureDescription[/TD]
[/TR]
[TR]
[TD]FixtureQuantity[/TD]
[/TR]
[TR]
[TD]FixtureDrawing/StockNumber[/TD]
[/TR]
[TR]
[TD]FixtureNotes[/TD]
[/TR]
</tbody>[/TABLE]
This is where I'm not sure what to do. So for every Kit, it'll have the part number, the Op number, the shelf, and location, and then a whole bunch of tooling, which could include a handful of tools, multiple fixtures, and many other parts.
What would be the best way of building each kit with all these tools? i was hoping there's a way that i only need to fill out one kit, but then able to tie in as many tools as i want per kit, for example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]KitID[/TD]
[TD]PartNumber_FK[/TD]
[TD]Op[/TD]
[TD]Shelf[/TD]
[TD]Location[/TD]
[TD]Tooling[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]107[/TD]
[TD]10[/TD]
[TD]1[/TD]
[TD]A-1[/TD]
[TD]Boring Bar
Turning Tool
Fixture
Etc...
[/TD]
[/TR]
</tbody>[/TABLE]
Is this possible? or will i need to basically fill out the same kit each time and tie each separate tool with it and then after maybe make a query that shows per each kit, all the tools associated with it?
Hoping this isn't too confusing lol any help would be greatly appreciated, cheers.