Pop-up field of names from same table
I have a table of students with two billing designations: primary and secondary (pop up field that lets you choose between the two). I would like to add a pop-up or drop-down field to that table that lists all the students with the "primary" designation.
Will this involve a self-join relationship? Or creating another table that automatically adds records based on what students are designated as "primary"?