Hi
I have written a reporting database for the staff to write their reports for the end of year.
There are 3 tables involved, apart from lookups.
Staff, list of staff members
Pupils, list of pupils linked to the relevant staff member who has to report on them,
Report, one per pupil,
The way the staff work here, I have had to make the 4 basic field in the report of Contribution to Form, Attendance, Behaviour and Comments, all work from drop down lists each one has a choice of 4 categories, ranging from Excellent, through good to satisfactory and finally to Poor.
So the staff click on the kid's name, select new report then they have to pick from 4 drop down boxes ( described above) finally they can type a personal statement in the final additional comments box.
This record is saved in the table as a row of 4 numbers, denoting the choices made from the drop down boxes and a text field for the more comments part.
Originally the printing was to be done by the tutors, however the Senior Leadership Team have decided that they must review all the reports before they are printed, to prevent mistakes going out.
I had set this up so that at the pre-printing stage, there was a load of If statements in the custom code for the Printer-friendly page that replace the numbers stored in the database with pre written statements, each one being personalised with the details from the pupils record to say his or her, he or she and using the pupils name, as well as pulling info from the staff table to add a personal touch to the bottom of the report.
This produces a reasonable looking report, and it appears to be personalised.
Now they have moved the goal posts so that the printing can be done by one of the office staff, so I need to find a way of printing all the records that have a report added and setting a flag in the record to say that it has been printed.Or set a flag on the pupil to prevent any further changes made to the pupil's report record.
Can I do this from within the existing structure or do I need to add a view to allow me to have a batch print operator?
Remember the structure of the tables
Staff
|
|
|
pupils
|
|
|
Report.
All help readily received please
Many thanks for all the past help too