Skip to main content
Question

Drop down subject to a previous drop down

  • April 30, 2019
  • 0 replies
  • 22 views
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.
    This topic has been closed for replies.

    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.
    Terms & ConditionsAccessibility statement