Discussions

Expand all | Collapse all

Is it possible to set up a relationship between two fields that allows you to narrow choices.

  • 1.  Is it possible to set up a relationship between two fields that allows you to narrow choices.

    Posted 08-15-2018 15:35
    For Example
    Field X (Multiple Choice)- Contains - A,B,C,D,E   
    Field Y -  (Multiple Choice) - Contains - 1,2,3,4 .
    When the user creates a record using a form.
    If you choose A in Field X,  is there a way to only display 1,3  in Field Y?


  • 2.  RE: Is it possible to set up a relationship between two fields that allows you to narrow choices.

    Posted 08-15-2018 16:47
    I haven't had experience with it, but was also looking into this possibility of Conditional Dropdowns this morning actually.  It looks like this can be done only through a reference field from a relational table.  So if you were to create a separate table for those multiple choice fields and join it to the table you are looking to add this to, then you might be able to get it to work.

    https://help.quickbase.com/user-assistance/conditional_dropdowns.html

    This link helps explain it a bit more.