relating projects to a 3-table many-to-many join

  • 0
  • 2
  • Question
  • Updated 4 years ago
  • Answered
I have three tables joined with many-to-many relationships between locations, people, and skills. We have projects in another table that relate to locations, people, and skills in various ways: a project can be related to one person and their many skills, multiple people with one skill, people in a region calculated by a set of zip codes, etc.


How to I best join the projects? I’d like to see—for each location, person, skill and whatever breakdown I need to pull among these tables—what the related projects are.

I've attached the relationships I have so far.


Photo of Hizuru

Hizuru

  • 10 Points

Posted 4 years ago

  • 0
  • 2
Photo of Lovell

Lovell

  • 0 Points
Hello, 



My name is Lovell and I am with QuickBase Care. Thank you for your question! In this case, you may want to submit a support case so we can get a closer look at your set up to assist further.  Please log into QuickBase and hit HELP, then manage support cases to submit a support case. 



Regards, 



Lovell

QuickBase Care