AnsweredAssumed Answered

Still having issues trying to get relationships working in Gradebook

Question asked by gswest on May 26, 2017
Latest reply on May 26, 2017 by gswest

So i've come a long way in this database but I still have things I can't figure out. I'm attaching a copy of the offending database here.

 

Question 1) I need the _fkAssignmentID to populate in the StudentAssignments table when a new record is created but I can't figure out how to do it. As it is when I enter an assignment, I have to go in and manually add the correct ID.

 

2) I want to be able to chart AVG, MIN, MAX, STD, etc for specific course assignments.

 

3) The database does, at least at a base level, what I absolutely need at this point. But I want it to be a little more flexible for data analysis. Also, ideally I want to be able to run reports based on a specific class, specific student, or specific assignment.

 

Any help would be greatly appreciated.

 

Best,

 

Geoff

Outcomes