enter parameters window

Enter Parameters Window with dynamic field updates

I can see the potential of the Enter Parameters window on Edit Queries feature, which can have a number of fields such as text boxes and drop down lists. It would be great if for example:

A dropdown list field on selection dynamically updates the returning dataset to another dropdown list field which its connected too. With this capability it could save time and the need to develop additional excel plugins to retrieve data for analysis.

The availability to connect to various data sources is already provided, but using the Enter Parameters window as a user interface to customize to pull data based on certain selection criteria would be great!