Select a Name on a dropdown list and populate (display) the other fields with info.
I am having some trouble.. getting this to work.. It's probably something simple but I can't get it to work.
Problem: I have a field that is a drop down list to select Teacher Names.. When I select a teacher name, i want the other fields to show the correct information of that teacher like email and subject.
I have two table (Teacher info) and (Teacher Subject).. Relationship link on Teacher info: id and Teacher subject: id
So when I select a teacher, the information does not show up.. I looked up on youtube but nothing.. Any help.. thanks..
if I click on next record the information shows up but I select a teacher name that other fields stay the same.
I created a simple database but can get it.. look at the image below..