Pathways for finding data

I have a functional workflow that allows someone to load a list of ID values and then have it return data from various DB tables based on those values.

I am trying to figure out if there is a way to allow for multiple paths to getting data results, such as but not limited to:

  1. A search dropdown of all IDs that are available.

  2. A dropdown of all countries that have relevant data.

  3. A dropdown of all entity names that have relevant data.

Is there a way to have someone pick what path and then allow them to pick a filter or load the file?

Thanks for any insight on how something like this might work.