How do I create a partially completed datasheet on-the-fly for data entry

Desmond_Fox

Registered User.
Local time
Tomorrow, 02:40
Joined
Dec 3, 2014
Messages
12
Hi,

I've been struggling with this challenge for a week.

I have a primary school database. I'm trying to create a form that allows a teacher to select their class, then select a subject and then be presented with a data entry form in a table layout that lists only their student's names in one column and an empty column to input results for the selected subject.

To simplify my explanation to just three tables, lets say my tables are:
> Students....which stores student names plus a foreign key for their class
> Classes...which stores the class name
> Results...which stores all the results (fields are: ResultID (key), StudentID, SubjectID, Result, DateofResult)

I have no problems creating reports where the teacher selects their class from a combo box to generate a report based on a crosstab query. But this one has me stumped.

Any pointers in the right direction would be gratefully received (even the terminology used for this sort of thing would be a help so I can do better research).

Thanks
Des
 
Classes and student and results seem to be related. Results may be related to student or class, I can't tell from your post.

I'd build form or combo box Class related to subfrm or combo box student and or combo box subsubform result related to subform student. Results and students table probably should be combined.

Your thinking seems to be on the right track. If you can articulate what you want, you're almost there. Build or draw a mockup of what you want thinks to look like and then creaste the real thing
 
Thanks llkhoutx, I seem to be having some success by creating a temporary table.

EDIT:
I thought I would expand on this solution to anyone having a similar problem.

  1. I made a form with a combo box to select a class of kids
  2. a button on the form initiates a query. The query populates a temporary table with student names
  3. then the macro opens up a form that references a datasheet based on that temporary table
  4. then I use an append query to add information from the form to the relevant tables


Des
 
Last edited:

Users who are viewing this thread

Back
Top Bottom