OK, so your lucky day. That is native functionality called Conditional drop downs .
https://help.quickbase.com/user-assistance/conditional_dropdowns.htmlIt's a shame that you have such short drop down lists to work with, because and it is truly impressive to see how efficiently Quick Base filters the next drop down when there are thousands of records.
In you case, you just need to set up a master table to drive the drop down list for field 1 and then another table for the valid choices in field 2 and then make a relationship where One field 1 has many field 2s. I suggest making the Key field of these tables the actual text choices and not Record ID#.
Then you will use those tables in a relationship back to your data entry record to provide the drop down lists.
Post back if you get stuck.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------
