Hello all,
I'm trying to work up a database to help us (a small electronics manufacturer)track what equipment we have for which terminals(<-- Things you put on the ends of wires). This is how it started, anyway... This is my first real db, so before I get things all mucked up, I thought I'd kindly ask for some advice.
The current state is attached with a little bit of trial information in it. I'm interested in any recommendations you might have on what I could do to improve it, but here is the specific question:
I need to add crimp height data. The TerminalEquip table relates which tools crimp which terminals. Now, each of these records (representing tool to terminal combinations) might be used for one or more different wire gauges. Each of these different gauges will have individual crimp height specifications. This is why I created the CrimpHeights table. I added an autonumber to TerminalEquip called ProcessID which could be used to look up the record, then the gauge and crimp specs could be added.
I'm not sure this is the right approach. If someone could look at the db, and maybe let me know if I'm going in the right direction or not, I would be very grateful. Thanks for reading.
I'm trying to work up a database to help us (a small electronics manufacturer)track what equipment we have for which terminals(<-- Things you put on the ends of wires). This is how it started, anyway... This is my first real db, so before I get things all mucked up, I thought I'd kindly ask for some advice.
The current state is attached with a little bit of trial information in it. I'm interested in any recommendations you might have on what I could do to improve it, but here is the specific question:
I need to add crimp height data. The TerminalEquip table relates which tools crimp which terminals. Now, each of these records (representing tool to terminal combinations) might be used for one or more different wire gauges. Each of these different gauges will have individual crimp height specifications. This is why I created the CrimpHeights table. I added an autonumber to TerminalEquip called ProcessID which could be used to look up the record, then the gauge and crimp specs could be added.
I'm not sure this is the right approach. If someone could look at the db, and maybe let me know if I'm going in the right direction or not, I would be very grateful. Thanks for reading.
Last edited:
