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:
A search dropdown of all IDs that are available.
A dropdown of all countries that have relevant data.
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.