Tables and Relationships Question

[Lynn]

I'm wanting to generate evaluation forms for student assignments for a series
of dates. So far I've created the following tables:

Students Table
------------
Name
*StudentID


Assignments Table
--------------
StudentID
*Assignment
Work Location
Start Time

*=Primary key


The problem I can't get my head around is how to handle the table structure
and relationships for the series of dates on which the student will be
training on the assignment. Using a report, I'd like to generate one
evaluation sheet per student for each of the 7 dates they will be performing
the assignment. I know this can be done using separate reports for each date,
but our class sizes are large, and the instructor doesn't want to have to
collate all the evaluation forms for a given student. Is there a way to
accomplish this through table/relationship structure?

 

[Steve]

Start with the following tables ..........
TblInstructor
InstructorID
InstructorTitle
InstructorFirstName
InstructorLastName

TblStudent
StudentID
FirstName
MI
LastName
<other student fields >

TblAssignment
AssignmentID
StudentID
InstuctorID
AssignmentDescription
AssignmentLocation

TblAssignmentDate
AssignmentDateID
AssignmentID
AssignmentDate
AssignmentStartTime
AssignmentResult

Your report needs to be a report/subreport. Base your main report on a query
that includes th first three tables. Base the subreport on
TblAssignmentDate. Set the LinkMaster and LinkChild properties to
AssignmentID.

Steve
(e-mail address removed)