Drop down subject to a previous drop down

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have a 
COMPANY table
CONTACTS table
   In the CONTACTS form there is a selection drop down for COMPANY this contact is 
   associated with.
PILOT PROJECTS table
   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.