So want to make sure I get this very simple database set up correctly wanted to run it by you all for your comments and suggestions. I figure since I am paying monthly for membership on this site I should take advantage of some very knowledgable talent here.
So I am try to create a database that will allow me to generate the type of report you see below attached. Basically I have a table of students (and I'm not sure I set this up right so I have thick skin let me know what your thoughts are) and from the table need to generate the report. As you can see from the report the Page Header will contain the student name and seminar (homeroom) teacher but then in the detail section of the report I need to print the dates in the date field in sequential order first the under the dates will go the interventions.
But here's the thing..each student record has a field for each category and whether or not the student 'needs' the intervention. For example if the Numbers and Operations field contains a "yes" or "1" then I would need for the Numbers and Operations intervervention to display on the report. I figured I would use an exandable textbox and only show the textbox 'if' there is a 'yes' in the Numbers and Operations field. Then I need to print the next date in sequence and then check to see if a student has a "yes" or "no" in the next category, "Algebra Functions".
There may be a senario where the student ONLY has a 'yes' on one category ( in other words only need intervention in one area) like "Data, Statistics & Probability" and that would go under the first date of February 1 - 15.
Hope this makes sense. Please let me know if you have questions.
I've also created a sample database to show what I have done thus far. No relationships set up.