Changing record picker value based another record picker

If you're talking about changing the value of the 2nd record picker - you can use form rules to change the value of the reference field, for example.

If you're talking about having the 2nd record picker only show certain values based on the selection of the 1st record picker, check out this online help article on "Conditional Dropdowns".   

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

------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/
------------------------------

One method would be to use dynamic form rules and many multiple choice text fields.

Example Fields:

• Multiple Choice Field1
  • Choice A
  • Choice B
• Multiple Choice Field2
  • Choice C
  • Choice D
  • Choice E
• Multiple Choice Field3
  • Choice F
  • Choice G
  • Choice H

Dynamic Form Rules Example:

• If Field1 is A, show Field2
• If Field1 is B, show Field3

------------------------------
Adam Keever
------------------------------