Keeping track of Items and their parts...
I work in film/television and I'm trying to keep track of equipment that is on our TV show. When I get I light, for instance, it comes with all sorts of parts. I could receive a various parts at various times, so my goal is to create a Transactions table that will pull equipment names from my "Equipment" table.
Using the picture as an example, I would create a "10K Baby Tener" record. I'm sure I would need to create an individual record for "DTY Globe 10,000W" and for all its various parts.
My question is, when I add a "10K Baby Tener" to a new transaction, how do I pull up the 10K's related records, similar to the picture...