Hi @greg.bull, welcome to the forum.
Am I right in saying you want to:
- create a UI with dropdown lists.
- The selection will result in a server call.
- The server call (through uplink) will run an SQL query to your database
- Then present it to that data to the user?
This was a nice recent example from the forum that might showcase something similar:
On the front end you could have your dropdown lists and then a Button component.
the button click event could then call the server function sending the arguments country and location.
The return value from the server call could be the rows from the database that you could then use to populate your UI.
Here are some relevant anvil tutorials that might give more insight.
Let us know what else you need…