Skip to main content
Question

Need help setting up relationship between courses and instructors

I'm new to QB, but have attended some live virtual trainings and explored my new employer's current setup of QB.

What we're trying to accomplish is:
We have many training courses in one table. We have many instructors in another table. We'd like to identify instructors as being qualified to teach select courses. One instructor could be linked to dozens of courses. One course could have dozens of instructors. 

When I try to make a relationship between the two tables as it is, I seem to only be able to assign 1 instructor per course or vice-versa (depending what I choose as the parent). 

What am I missing?



------------------------------
Graesen Arnoff
------------------------------
    This topic has been closed for replies.

    AdamKeever1
    Forum|alt.badge.img+2

    @Graesen Arnoff , for this you need what is often called a 'join table'. You could call it 'course instructors' or 'instructor courses' or something along those lines.

    One 'course instructors' will have many 'courses' in one relationship and will have many 'instructors' in another relationship.



    ------------------------------
    Adam Keever
    ------------------------------
    Terms & ConditionsAccessibility statement