Drop down subject to a previous drop down

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have a 
   In the CONTACTS form there is a selection drop down for COMPANY this contact is 
   associated with.
   This form also has a selection drop down for COMPANY
I would like to have a multi-select field drop down displaying only those CONTACTS that are associated with the COMPANY selected in the Company drop down.
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
There is not a way to filter a multi select field type. 

It is possible,  however, to have a many to many relationship where 

One Company has many Contacts
One Company has many Pilot projects
One Contact has Many Pilot Project Contact Assignments
One Pilot Project has Many Pilot Project Contact Assignments

The Pilot Project Contact Assignments table is the "join" table for the
many to many relationship.  That drop down of Contacts can be filtered for just the Contacts for that company.