Hi All. I think what am trying to do is really basic stuff, but for the life of me I can't work out how to do it! Appreciate any help or pointers anyone could give me.
I have a very simple database which includes names and addresses. All I want to do on my site is have a dropdown list showing all the names from the database (I've got that bit working!), and when a user selects a name from that list, display the corresponding address in a text field.
I have achieved this in what I think is a very over complicated way with code that searches the database using the value from the dropdown list and then displaying the result in a repeater. But this just seems over kill. I don't want to use a repeater because there will only ever be one result to display.
Surely there must be a simple way to just read the record in and display the values in a text field?
Many, many thanks!