Students with conflicts help

[gint32]

I am hoping someone can guide me on the correct path with setting up a from for my student.mdb, that has the facility to flag up(somehow) whenever two or more students having the same classes together and have some sort of conflict such as a past history of fighting or getting in trouble (e.g partners in crime). So as I can reschedule for different times for these individuals. I have searched for a sample DB online the closest I could find was that law firms need this type of system to manage client conflicts, but could not find any samples of how they perform this(A Forms-Based Conflict System)

So presently, (statement of the obvious I know) I have a tblstudentsdetails, TblClassSubjects, tblAttendances

Thinking, I should have a TblConflicts(UsingUniqueID) and TblConflictTypes and some sort of way of flagging up with vba Dlookup or ?, whenever two or more students are being booked for the same class on the same day. via report, msgbox or your suggestion.





Thanks in advance for any suggestions on how to do this.

[ranman256]

Select qsStudentsTrouble,qsClassRoster
where qsStudentsTrouble.ClassID= qsClassRoster.ClassID
and qsStudentsTrouble.StudentID =qsClassRoster.StudentID

qry: are students that had trouble, and their classes.
qry: qsClassRoster pulls all students in current classes.

[gint32]

Many thanks for the guidance..