RyanWhitener
5 years agoQrew Cadet
Many to Many Relationship to a Many Relationship?
So I am not sure how to fully label the item I am working through, so I will do my best to describe it.
I have a Jobs table (great grandparent) to a Packages table (grandparent) to a Breakers table (parent) to a Coordination (child). The particular case I am trying to wrap my head around is: Within the Package table, there is a field called "equipment type", one option is "panel" and another is a "transformer". Easy enough right, So now we have (2) records in the Package table. Well when "equipment type" is equal to "panel" a "breakers'" report table is accessible to that individual to begin listing the breakers within that panel. Still simple enough. Now we get complicated. I want to map out/describe where they breakers go. So I created this "Coordination" table and related it back to both the Package table AND the Breaker table. The reason being is I wanted to select a breaker and relate it to a separate piece of equipment.
Example. (Package Table)Panel MP2 has a breaker named XXX (Breaker Table) which provides power to XFMR 2 (Package Table).
Now writing it out, I am wonder if I over complicated it and should just have (2) relationships between the Package Table and Breaker Table. The only extra piece to that is having it filter based on the Related Job I would be working in. So I can't select a "Panel" from the wrong job.
------------------------------
Ryan Whitener
------------------------------
I have a Jobs table (great grandparent) to a Packages table (grandparent) to a Breakers table (parent) to a Coordination (child). The particular case I am trying to wrap my head around is: Within the Package table, there is a field called "equipment type", one option is "panel" and another is a "transformer". Easy enough right, So now we have (2) records in the Package table. Well when "equipment type" is equal to "panel" a "breakers'" report table is accessible to that individual to begin listing the breakers within that panel. Still simple enough. Now we get complicated. I want to map out/describe where they breakers go. So I created this "Coordination" table and related it back to both the Package table AND the Breaker table. The reason being is I wanted to select a breaker and relate it to a separate piece of equipment.
Example. (Package Table)Panel MP2 has a breaker named XXX (Breaker Table) which provides power to XFMR 2 (Package Table).
Now writing it out, I am wonder if I over complicated it and should just have (2) relationships between the Package Table and Breaker Table. The only extra piece to that is having it filter based on the Related Job I would be working in. So I can't select a "Panel" from the wrong job.
------------------------------
Ryan Whitener
------------------------------