Hi there, @johnnyharte… this article (specifically the latter part of it) should get you what you need.
In a nutshell, your second dropdown is a search for choices with a constraint where some field is equal to the value selected in the first dropdown.
Hope this helps.
Best…
Mike