AnsweredAssumed Answered

Bullying Database

Question asked by JimKotz on Aug 20, 2015
Latest reply on Aug 20, 2015 by JimKotz


Bullying Database


I'm trying to make a Bullying database for our school. I have a table called Students and a table called Bullying. I have a field call Bullying::StudentID_FK that I have related to the Student::StudentID_PK field. Can I use that set-up to get the student name, grade and teacher for both the Bullied student and student who is doing the bullying in my Bullying table? I was thinking maybe if I did a Bullying::BulliedID_FK and Bullying::BullyID_FK and related both of those to the StudentID_PK. Or do I need to create another table of line-items for each Bullying incident. Thanks in advance. Jim