Use Queries in Edit-UI Dropdowns

you are here (click to zoom) - discover the stack

Dropdown fields (Related-Entity or String) in the Edit-Form can be configured to show values from a Query.

They can also be cascaded - so that a selection on one dropdown changes the list of possible items on another dropdown.