Show results in textfield dependent on a selection in a dropdown menu
I've got a table in a database (tableA) and a PHP page which contains one form (form1).
tableA has two fields called subject and bookTitle.
The first field in the form1 is a dynamic dropdown list that contains values from the field bookTitle in tableA.
The second field in the form1 is a textfield and needs to automatically be filled with the corresponding subject from tableA dependent on what the user has picked in the dynamic dropdown above.
I've got all of my connections set up correctly and I've got the text for the dynamic dropdown list OK. I'm just a bit stuck on the automatic insertion of the text into the textfield after the user has made their selection within the dropdown list.