Generating a drop down list from a table
So I currently have two tables. Table one consists of tutors which contains around 10-15 records. This table will slowly grow and I appreciate its tiny but currently thats not the issue.
The second table is a list of students. We currently have around 400 students but as we get a tutor this will jump up 30 or 40 at a time.
What I would like to do is two things.
Firstly, make the one to many relationship between the two tables. Currently - for some reason - its one to many but the wrong way around. Many tutors for one student. No idea how to resolve this.
The second thing is to make it so that the tutor field within the students layout would be a drop down box of all the names of the instructors. This is so our sales people can book a student in with an instructor and pick that instructor from the list rather than manually typing the name in.
The reason we want it linked is so that on the instructors layout we can make detailed reports of all the instructors pupils.
Thanks in advance.