Hi,
I want to design a system whereby I have stored in the database records of my students. I want to be able to find a student easily and then assign a warning against his/her name based on behaviour and also put a date/time stamp against that. The warning system can go up in one session.
So for example, studentA has misbehaved, they receive warning1 on 16th March 2010 at 0915. They continue to misbehave, escalate to warning2 16th March 2010 at 0930 and so on until warning 5.
I then want to be able to produce easy reports. The whole system should be really easy to use and quick to input. What tables do people suggest for this. I will use a switchboard and queries obviously to pull the necessary data, just unsure about logging it all really.
Thanks,
sqpr