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

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?

Micah

0 Points

Posted 3 years ago

3 years ago

QuickBaseCoach App Dev./Training, Champion

59,768 Points

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.