The primary key that connects all of my tables is the StudentID #.
However, when I am entering data it is easier for me to enter by student name, than by their number.
In a layout, how can I create a drop down box by student name (first and last) and then have their ID number entered in the box to make the necessary connections? I believe its called a "control label" in access?
Thanks for your help!