AnsweredAssumed Answered

Select a Name on a dropdown list and populate (display) the other fields with info.

Question asked by bvillarreal on Sep 24, 2013
Latest reply on Sep 24, 2013 by philmodjunk

Title

Select a Name on a dropdown list and populate (display) the other fields with info.

Post


     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..

Screen_Shot_2013-09-24_at_9.49.57_PM.png

Outcomes