Forum Discussion

EvanBohan's avatar
EvanBohan
Qrew Cadet
5 years ago

Can you use a Table Relationship to do multi select drop down?

I have a table to table relationship there I can do conditional drop downs but it only allows for one choice.

Example:
When the Task Owner Title = "Electrician", the choices become the list of current electricians from the "Employees" table. 

But I need to be able to choose 2 electricians. 

Thoughts?

------------------------------
EvanB
------------------------------
Relationships
Tables and fields

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    You will need to duplicate the relationship and have two separate fiends for Electrician 1 and Electrician 2.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • EvanBohan's avatar
      EvanBohan
      Qrew Cadet
      5 years ago
      I was afraid of that. Was hoping I could do a List - User style. 

      Okay. Thanks!

      ------------------------------
      Evan B
      ------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    5 years ago
    Evan,

    Consider putting a child table in between the Employees and Tasks

    Tasks <<  Employee Tasks  >> Employees

    Now you can add as many Electricians to the Task as you need.  Also you can get business process info on each individually.   Maybe both start the task day one, but their is only one there on day two to complete it.      You know now who was assigned and who finished.


    ------------------------------
    Don Larson
    ------------------------------
    • EvanMartinez's avatar
      EvanMartinez
      Qrew Elite
      5 years ago
      Hi Evan,

      I would agree with Don's suggest that if you want to be able to attach multiple Employees and Tasks an Employee Tasks table is a great way to manage that. That way they would all appear on an embedded report in the Tasks table or Employees table with all the combinations and going forward you could use that for reporting as well using the relationships.

      ------------------------------
      Evan Martinez
      Community Marketing Manager
      Quick Base
      ------------------------------