I have two tables I am working with. One has student information, and the other has their addresses (Since a student may have multiple addresses for various reasons). I want to be able to link the address to the student in question.
This is no problem, other than the fact that our primary key (for import/export) purposes is the student’s ID number. What I am looking for is the ability to lookup by the student’s name (Which is a field in the student table) so that instead of typing in student ID, you can type in their name and get results.
How can I go about doing this? I feel like I am missing something obvious