Creating blank records from new part of a composite key

[ArdNut]

Hello

I'm creating a database for a school. it contains the following tables: 'Students' of which the primary key is StudentID, 'Subjects' of which SubjectID is the key and 'Exams' - ExamID.

Then, I have a table called 'Results' but with no primary key of its own - just 3 foreign keys from the other tables and another field which can be left blank let's call it 'Grade'. So the Results table would have the following fields:

StudentID*, SubjectID*, ExamID*, Grade

Now, I make a form which creates a new lets say ExamID and I would like to create records with all the combinations of all of the subjects and students, ready for the 'Grade' to be typed in. How would I go about doing that in the easiest way possible? This is assuming the Exam isn't based on the Subject directly.



Thank you

[June7]

Will probably be complicated.

Do a cartesian join of the 3 tables. Pull all 3 tables into query designer but don't set any links. Drag the ID fields to the grid. This should cause every record of each table to join with every record of the other tables, resulting in records of every possible combination. I have done this with 2 tables but never 3.

Now the trick is to determine which of these records need to be copied into the Results table. Do a Find Unmatched query between the cartesian dataset and the Results table to isolate the cartesian combinations not already in the Results table.

Then do INSERT SELECT sql action on the Find Unmatched query.