How to add cascading dropdowns

You've learned how to create a simple conditional dropdown list...but what if you wanted to take it one step further? What if you wanted to develop the form below:

The good news is that, if you know how to set up a single conditional dropdown, you know how to set up cascading dropdowns.

To add a conditional Departments field to your Employee form, follow the tutorial for setting up a conditional dropdown and add these steps:

• Add a Departments table

• Set up these relationships:

Note: These relationships will establish a conditional Department dropdown on the Employee form. You can also set up conditional behavior on the Departments form, so that users can first choose a country to see a filtered list of cities. If you'd like to do that, simply follow the steps for creating a single conditional dropdown.

• Set the Conditional Behavior property for the Employees: Departments field as follows:
  
  

QuickBase now filters the department list on the employee form, so that you see only those departments located in the selected city.

Related Topics

• Conditional Dropdowns

• Conditional Dropdowns: Basic Setup

• Another Option for Creating Conditional Dropdowns

• About Relationships

• Reference Proxies