Is it possible to build a many-to-many relationship between two tables that share a parent?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I had 3 tables to start. A Client can have many Sites and many Projects. I added a 'Project Sites' Join table, to record which of a Client's Sites are associated with which Projects. 

When I go to a Project and 'Add Project Site', I have to search through every Site to tie them together. Is it possible to limit my selection of Sites to only those that belong to the same Client?

Photo of Micah

Micah

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
No problem. Conditional drop downs to the rescue!

On the field for Related Site, look for the checkbox for conditional values.

The dialogue will let you say
After choosing related client, only show sites Where related client is equal to related client.

It will make more sense to you once you locate that checkbox for the conditional drop down.
Photo of Micah

Micah

  • 0 Points
Thank you! I was going down the wrong rabbit hole, but that was an easy thing to implement once I looked in the right place!