Skip to main content
Question

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

  • October 21, 2019
  • 0 replies
  • 27 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
    Forum|alt.badge.img+15
    • DonLarson
    • Registered
    • October 22, 2019
    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
    ------------------------------
    Terms & ConditionsAccessibility statement