Skip to main content
Question

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

  • August 15, 2018
  • 0 replies
  • 26 views

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?
This topic has been closed for replies.

  • Registered
  • August 15, 2018
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.