Originally Posted by
ArviLaanemets
I'm confused here! Do you mean you want an additional table, where incidents for every student are registered, or you want a new table every time when any incident for any student (i.e. a lot of single-incident tables) is registered? The 1st is OK, the 2nd is a NO-NO!
To do this properly, you need a table like tblStudentIncidents: StudentIncidentID, StudentID, IncidentID, IncidentComment, RegisteringTime
And I advice to redesign existing tables like
tblStudents: StudentID, Forename, Surname;
tblIncidents: IncidentID, IncidentDescription.
To register incidents, you need either:
A single form based on tblStudents, and a continuous subform based on tblStudentIncidents. Subform is linked to parent form by StudentID, and has controls like txtStudentIncidentID (hidden text box), txtStudentID (hidden text box), cbbIncident (visible combo box based on tblIncidents linked to tblStudentIncidents.IncidentID and displaying IncidentDescription), and txtRegisteringTime (hidden or disabled text box which has current datetime as default value). A new incident for active student is registered, when a new record in subform is saved (E.g. you create a new record in subform, select the incident there and enter it's description, and then leave the subform, select another record there, or start a next new record in subform. And until the record is saved, you can always abort the incident registering pressing ESC!).
or
A single unbound form with combos to select StudentID (e.g. cbbUnboundStudentID) and IncidentID (e.g. cbbUnboundIncidentID), with a continuous subform based on tblStudentIncidents. Subform is linked to parent form by pairs of StudentID, cbbUnboundStudentID and IncidentID, cbbUnvoundIncidentID. Probably at best you use disabled/locked combos linked to tblStudentIncidents.StudentID and tblStudentIncidents.IncidentID in subform, an editable text box to enter IncidentDescription, and again a hidden or disabled tect box with current datetime as default value. The subform will display all incidents of same type for student (depending on selections in unbound form). The rest is same as with 1st design.