I am populating the data of the dropdown using a SQL Query (which returns only one column) and I want to default the Dropdown selection to first item in the returned recordset. I also want to have the selection label be set to this value. How can I do this?
By default the dropdown defaults to and I have to select the first item.
I imagine this is easy, but for some reason I have been struggling with many different options tried.