Creating a relationship that enables me to auto enter data
I am attempting to create a database for student discipline that allows me to enter information on a particular incident (incident report) that could possibly list several students involved with one incident. I want to be able to enter the data in one table as student1 student2 and so on and have it atomically populate another table with a list of students. My goal (and I am not sure how to do this) is to be able to run several reports. Looking up a particular student and seeing how many cases he/she has been involved in, looking at each case, and looking at each type of violation and see what students have been involved.