Is it possible to have a conditional dropdown based on a many to many relationship in a grandparent?

  • 0
  • 2
  • Question
  • Updated 1 year ago
  • Answered
I'm having an issue creating a conditional dropdown in my services form.  

Tables: Project, Building list for project, buildings, equipment, services.  

Relationships: Project<building list for project, Project<Services, building<building list for project, building<equipment, building<services, equipment<services.   

In the services form, I have a selection for the project, and need the buildings drop down to only show the buildings that are in that projects building lists if that makes sense. and then another dropdown for the equipment in that building.

The dropdown for equipment in the building is working fine, but im having a problem figuring out how to relate the building to the project through the building list for project relationship.
Photo of David

David

  • 10 Points

Posted 3 years ago

  • 0
  • 2
I believe that I understand your question and it can be done natively.  But you would need to contact me via the information in my profile for one on one assistance with this.  The solution is too complicated to post here.  Its not crazy complicated but does require updating a table of users to indicate which project they are Focussed on.  Then "lighting up" the building List for that Project and hence lighting up the Buildings for those who qualify for the Project to choose.
Photo of David

David

  • 10 Points
Sounds good, phone or email?
You can contact me by email using the email address in my profile and I will give you a call.
Photo of Ryan Mcknight

Ryan Mcknight

  • 102 Points 100 badge 2x thumb
I have the same issue, I think.  I have States Table (grandparent), Networks table (uses state's list as child table to states), Providers table (acts as child to networks table/grand child to states).  1) I don't want to create a direct States to providers table, right?  that's duplicative?  The problem is that when I use the state's list as the drop down for the record picker, it shows the state multiple times rather than just once (as I want for those providers not in a network); yet I need it to show as state-list-network name for those providers in a network so that the relevant look-up fields will populate.  

EX)

I have provider A, that is in VA.  They're an independent provider, so I want to see only VA 1 time on the drop-down list vs 5 times because I have 5 Networks in teh parent table that belong to VA.

I also, in the same form, want to be able to pull in any associated network providers, from a duplicate dropdown but with state-list and network name in the drop-down field.

I hate the idea of having too many tables.