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 Dropdownshttps://help.quickbase.com/user-assistance/conditional_dropdowns.html------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/------------------------------
