Hi all,
I received some guidance here previously and am grateful for forums like this. My other project is on hold because the future of my company is in question at the moment, but I still want to learn more. I'm struggling with how to set up a particular relationship that fits into the many-to-many category, I've read a lot of material on this but am really struggling to visualize how it can work. What I have is a system where I am matching crimp terminals to crimp tools. Each of the tools is able to process a variety of different crimp terminals (many terminals to one tool). So far the structure is working OK but I need to make some additions to make it more functional. The problem is as follows:
- For some tools I have multiple instances of the same tool
- Some terminals may be processed by more than one tool (Either/or rather than one after another)
- Some tools have interchangeable die sets, in which case the terminal links to the die set then the die set links to the tool
I know that for the second line I should have a junction table to create a one to many relationship, or a multivalue field, but I am having a really hard time seeing how that would go together. Any guidance on this would be greatly appreciated!