Re: Getting subform to work

Thanks for your time Amy this is a tough one to crack. I'll study and mockup
the suggestions below an look forward to the form piece

Thanks,
Todd

"Amy Blankenship" wrote:


"TLuebke" <TLuebke@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0EB4782C-9F47-42D8-80D1-180ADB1A418F@xxxxxxxxxxxxxxxx
....

Let me restate what I think you said to make sure I understand:

tblCourses - The purpose of this table is to define courses
CourseID
CourseNumber?
CourseTitle

tblModules - The purpose of this table is to define the modules within each
course
CourseID
ModuleNum (will be 1-5 within each course)

I think this here is at least part of your problem. You don't have a single
unique identifier for each module, yet you're trying to Join on ModuleNum as
if it were a primary key. I'll get to a suggested design later, but just
thought I'd point that out here where it is obvious.

tblAssign - The purpose of this table is to define assignments within each
Module
ModuleNum
AssignID

tblLinkCourses -The purpose of this table is to define which courses a
student is taking right now
StudentID
CourseID

Note that this does not allow for any historical data.

tblSubmit - The purpose of this table is to define what grades the student
made on each assignment (submission?)
StudentID
AssignID
StatusCode

There are two more tables implied by your posts:

tblStudent - Defines Students
StudentID
FirstName
LastName
etc

tblStatusCodes - provides values for the lookin in tblSubmit
CodeID
Code

Now, this is how I might design it:

tblCourses - defines courses
CourseID
CourseNumber
CourseName

tblModules - defines modules
ModuleID
ModuleDesc (text field describing the module)

tblCourseModules - defines what modules are in what courses
ModuleID
CourseID
ModuleNumber (number of the module within the course)

Note that this allows you to reuse Modules so that, for instance, if you had
a Grammar module that you wanted to use in a writing course and a literature
course, you could do that.

tblAssign
ModuleID
AssignID
AssignOrder (makes it easier to know which assignment is which)
AssignDesc (short description of th assignment)

tblSemesters - defines periods of time a course can be offered (name it as
is appropriate for you)
SemesterID
SemesterStart
SemesterEnd

tblCourseOfferings - defines courses that are available for a given semester
CourseOfferingID
CourseID
SemesterID
CourseOfferingDesc - you'd use this if you were offering a course more than
once in a semester to distinguish between offerings

tblStudentCourseOffering - defines which courses a student is taking
StudentID
CourseOfferingID

tblSubmit - records student's grades on assignments
StudentID
AssignID
StatusCode

I've already spent loads of time on this and I know it's a lot to get your
head around, so I'll come back tonight or tomorrow am with the form design.
That way you can look at the two posts along side one another.

HTH;

Amy



.

Relevant Pages

  • Re: Getting subform to work
    ... tblCourses - The purpose of this table is to define courses ... tblModules - The purpose of this table is to define the modules within each ... tblSubmit - The purpose of this table is to define what grades the student ... AssignOrder (makes it easier to know which assignment is which) ...
    (microsoft.public.access.forms)
  • Re: One false Move & Ill Kill Ya Pug
    ... Ad assignment goes awry on MySpace.com ... A university student appears to be responsible for an advertising ... The school later traced the postings to a school computer. ... Adcenter and local police to report the threat. ...
    (alt.true-crime)
  • Re: teaching assignments - office - can you tell the orginal from
    ... If each student has a different assignment the issue becomes moot, ... the determined student can get around. ...
    (microsoft.public.office.misc)
  • Re: Really basic data entry question [Beginner]
    ... But I stand by the contention that it is an unrealistic assignment. ... I don't recall saying anywhere that I am currently a student? ... now who's trying to impress people.... ... So I'm not a total newbie but I am a relative newbie ...
    (comp.lang.java.programmer)
  • RE: Running a formula & For...Each
    ... So, if Cell A10 ... Assignment Title ... Student Score ... Open AccelTest Results.txt ...
    (microsoft.public.excel.programming)
Loading