I have 5 tables:
- SLOs + Concepts
- Modules + SLOs
We have a product organized by modules (Modules), and has student learning objectives (SLOs). Modules are assigned multiple SLOs, but SLOs can also be used in multiple Modules (Modules + SLOs).
We also assign taxonomy concepts (Concepts) to the SLOs, and many Concepts can be assigned to many SLOs (SLOs + Concepts).
If a SLO is assigned to a Module, I want to know what Concepts are assigned by association. In other words, a report displaying all the Concepts of the SLOs assigned to Module 6.
I built yet another table to manually create this relationship between 'SLOs + Concepts' and 'Modules + SLOs', but this is very labor-intensive and...stupid. It feels as though, if QB knows that a SLO is assigned to a Module, and these Concepts are associated with that SLO, it should know what Concepts are specific to that Module.