Forum Discussion

edcooper's avatar
edcooper
Qrew Assistant Captain
6 years ago

Drop down subject to a previous drop down

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.
Relationships
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.