Considering you want your answer in Fusebox, you should probably take it to
the Fusebox list (www.houseoffusion.com).
----- Original Message -----
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 8:30 AM
Subject: Design Question
> Ok folks I need some help with design...this is all stuff I know inside
out
> when I'm working with Access but am struggling when I try to put it in
terms
> of CF/Fusebox...
>
> 1. I need a login- once successfully logged in a teacher will only see
> his/her students. I got that.
> 2. So I need each for the teacher to choose a student (i'm trying to do
> this with frames-they pick from the list on the side) and the subject that
> they need to add grades for (math/english/etc)....I'd like to have it so
> that subjects are dynamic too (versus having separate pages for each
subject
> with the subject hardcoded by courseID... I'd prefer a table to fill with
> whichever subject was chosen).
> a. The teacher should have the choice if she/he wants to do 1
> student all subjects (which will take several "pages"- probably 5-6 to get
> through all the subjects + all the subcategories (ie: reads fluently/is
> cooperative...) So the teacher needs to be able to go through this page by
> page, doing an update at the end of each page (don't want them to lose too
> much info if power goes out)
> b. The teacher should be able to do the whole class by subject. ie:
> she/he picks math and each page has a different student/same subject.
> (update being saved after each student page is complete-as teacher goes to
> next student.
>
> So they'd be filtered on several different levels.
> I'm trying to figure out how to do all of this without it being unweildy-
> (ie: to hook teacher-student 3 tables are involved. To add a grade there
> are 4 tables- one with student info/one to hold the grade and 2 reference
> tables-one for the subject and one for all the subtopics of each
> subject....)Or maybe more appropriately I'm trying to figure out how to
chop
> it up appropriately.
> In Access I would make a main form and add all the subforms. The
> subforms would use specific updatable queries. The subforms would be
> attached to the mainform by some primary/foreign key combo. (so I could
> have 10 different subforms hooked to the main form) How do I accomplish
this
> in CF/Fusebox? Right now I have lots of pieces but they are not
> attached--how should I stitch this together?
> I wrote up a bunch of fusedocs but now I'm second guessing everything....
> Any ideas?
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
