If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tables and Relationships Question
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? |
Thread Tools | |
Display Modes | |
|
|