Forum Discussion

GraesenArnoff's avatar
GraesenArnoff
Qrew Member
3 years ago

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...
AdamKeever1's avatar
AdamKeever1
Qrew Commander
3 years ago

@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
------------------------------
GraesenArnoff's avatar
GraesenArnoff
Qrew Member
3 years ago

Thanks. That's exactly what I needed. It wasn't intuitive that this was necessary, but it appears to be doing what I need. 



------------------------------
Graesen Arnoff
------------------------------