AnsweredAssumed Answered

How to structure a daily student update DB

Question asked by VincentDavis on Jun 6, 2011
Latest reply on Jun 7, 2011 by philmodjunk


How to structure a daily student update DB


Quick/simplified senerio.

Have a table with a list of student (problem children). We track the current status of each. For example (on medications, needs extra supervision.....) We have a list of these. I was thinking of a table with a field for each (maybe just a check mark). The types of reports I need are for example, history of when each status change, current status.

My question is sould each status change require that each field be copied or can updates only change on field. Not really sure how best to do this.I am even having a little difficulty explaining so I hope this makes sense.