# README

Comment:
Simple database to show a possible method of entering results for students. See README report to see contents of this table.


Comment:
StudentResult to resolve the m:m relationship between Student and Test and to store the result for each student in each test. There is a non-duplicates key on StudentId|TestId, to ensure that only one result per test per student is recorded.


Comment:
FilterResult - selects just the test results so far (if any) for the required test as indicated on the ChooseTest form.


Comment:
StudentInTest - uses an outer join to select all students in Student table, showing marks, if any, from the FilterResult query. Note that this is a query based on the result of another query.


Comment:
Look at the join in the StudentInTest query - right-click on the line to see the join properties.


Comment:
ChooseTest - has listbox for user to choose the required test. Command button is disabled initially (via property box) and enabled when a test is chosen. Clicking on the command button opens the student result form.


Comment:
StudentResult - is based on the StudentInTest query, and opens with a list of results (if any) so far for this test. User chooses student from list box then enters mark. The form AllowAdditions property is set to No to remove the new record row at the end.


Comment:
The same student list is used throughout. In practice, different lists will apply for different tests, so this example could be extended to cater for that.


