Make the drop-downs for host and sub a search text-box like the student section. When a user types in a name the system searches for the top 3-5 best matches for what they typed. They then can select the list for the correct one populating the field. If they just enter a name that is not in the database then they cannot create a record and an error message appears saying the fields need to be valid.
Make the drop-downs for host and sub a search text-box like the student section. When a user types in a name the system searches for the top 3-5 best matches for what they typed. They then can select the list for the correct one populating the field. If they just enter a name that is not in the database then they cannot create a record and an error message appears saying the fields need to be valid.