Discussions

Expand all | Collapse all

Drop down subject to a previous drop down

  • 1.  Drop down subject to a previous drop down

    Posted 04-30-2019 19:46
    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.


  • 2.  RE: Drop down subject to a previous drop down

    Posted 04-30-2019 20:12
    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.