Condensed it! The more I thought about what you said, the more I realized I was complicating things too much. (at least until I'm way smarter...).
So, in looking at these three tables, I'm wondering how to connect the spare part with the job it was used on? As I said, the same part could be...