Conditional Value List Issue
Okay, so let me explain my situation and my issue. I am a student and I assist my teacher with his database. Over the years, he has created a database that helps him grade, organize, contact, etc. Well, we have a layout for grading projects. Currently, he has a value list with ALL of his students in alphabetical order that he must scan through to choose the student he wants to grade. I had the idea to create a conditional value list, that will allow him to first choose a class, then choose a student from a value list of only students in the specific class. That was the easy part.
BUT, on this layout, there are fields that display information about the student being graded (ID number, age, grade, period, etc.). Before, these fields displayed the information for which ever student he selected from the long list of students. But after I created the conditional value list, when he chooses a class, the fields automatically display the information for the first studenrt in the conditional value list. Then when a differnent student is choosen from the list, the information in the feilds stay the same. No matter which student is choosen, the infortmation belongs to the student at the top of the list. It won't change unless I choose a different class, then again the information changes to the student on the top of the list belonging to that class. I have tryed every thing I can, but can not fix this issue. If you have any questions, please let me know. I will be glad to answer them or provide more information about the issue. Thanks in advance.