Design Question

[cornishteeth]

I am planning to create a database and need a little guidance on how to get started. I want to create a dB that tracks students going through our command and assign an instructor to each student (sort of like a mentor to the student) I understand how to create the input form for the students information and whatnot. What I can't comprehend is how would I automatically assign a next sequential instructor from a table of instructors. How can I enter the information for a student and at the end, the next instructor from the list appears. At the end of the instructor list, it would then begin again at the top. Any guidance on how to do this would be most appreciated.

Cheers,

Frank

 

[bat17]

I have not thought this all the way through but assuming that you have a table structure that will let you group by instructor, and do a count on students, then you can just make a query sorted ascending and pick the instructor off the top each time. Whilst this may not give you your instructors in strict rotation it will ensure that no instructor gets two students until everyone has at least one.

HTH

Peter

 

[cornishteeth]

The problem is the ratio between instructor to students. There are way more students than instructors, so an instructor could ultimately have more than one student.

 

[bat17]

that is not a problem as by taking the min it would just keep pulling out instuctors untill every instuctor had a student before pulling an instructor a second time