I need to populate subfield

[patrickbartel]

Hi, I am building a small database for my class room for planning and grading. I have 3 grades for this class and when I create an assignment I want to be able to choose if this assignment is for which of the 3 grades. After I have selected which grades the assignment is for I want it Access to populate a subform where I could then enter the grades.

A screen shot of a rough draft is attached.

Thanks.

[NeoPa]

After you've selected the grade for the assignment you want to enter the grade(s) for each student?

Is this the same grade in both cases, or are you asking a question using the same term to mean two separate things? I'm confused.

[nico5038]

Your grades are confusing me.
I would expect a class to have students that are having a certain grade (e.g. 1, 2 or 3). Depending on the grade of the assignment the students are filtered (e.g. grade 2 assigment for students having grade 2 or 3) to do an assignment and for these filtered students the score will be recorded.

Just an idea, but with this assumption as an example I hope you can clarify your requirements.

Nic;o)

[patrickbartel]

To Clarify, the Grade stands for the child's current grade like Grade 1, or Grade 2. The column % stand for the grade such as 80% or 90%. This is a rural school so there are more then 1 grade per class. Some assignments are for all grades and some are for just 1 or 2 grades.

I want the subform populated when I create reports for the kids so they know what is due when etc.

[nico5038]

OK, then the children's table will need to have the grade recorded.
As you have assignments for all grades I would recommend to record a GradeFrom and GradeTo on an Assigment, thus making grades for all (or a range) possible.

After defining the Grade(s) for the assignment you can filter the children in a subform with the proper grade(s) and record the % scored/finished.

Getting the idea ?

Nic;o)

[NeoPa]

This is certainly clearer now the use of the same term to represent two ideas has been explained (still not a good idea ever though of course), but I'm still a little unclear what you're asking for help with.

It seems clear that a table would be required to represent each child. This table must have a field to indicate the relationship between the child and the form grade the child is a member of too. The main form would be bound to this table. I would expect a separate table to be required to represent (one of) the test(s). Each record would refer to a child and would have a field to store their score, or test grade. The subform would be bound to this table.

This may all be obvious to you. If so, what exactly are you asking about? What help can we offer?

[patrickbartel]

This is certainly clearer now the use of the same term to represent two ideas has been explained (still not a good idea ever though of course), but I'm still a little unclear what you're asking for help with.

It seems clear that a table would be required to represent each child. This table must have a field to indicate the relationship between the child and the form grade the child is a member of too. The main form would be bound to this table. I would expect a separate table to be required to represent (one of) the test(s). Each record would refer to a child and would have a field to store their score, or test grade. The subform would be bound to this table.

This may all be obvious to you. If so, what exactly are you asking about? What help can we offer?

Thanks. Yes, that makes sense.

Question: When I am done entering all the assignment info (e.g. type, start date, due date, etc) I want the appropriate (Which ever grade(s)) students to populate the subform (the subform would consist of another table explained in the last post.

[nico5038]

This can be achieved by filling the linkage fields for the subform with the filter needed.

But first you would need to establish the selection (filter) criteria. We know the Grade selection, but not sure what to do with the Start/Due date. Guess they are a guideline to guard progress, but not sure.

Nic;o)

[NeoPa]

patrickbartel: Question: When I am done entering all the assignment info (e.g. type, start date, due date, etc) I want the appropriate (Which ever grade(s)) students to populate the subform (the subform would consist of another table explained in the last post.

Again, you state what you want but give little or no indication of what we can help with. Where are you stuck? We are not about to give up and just do everything for you. You have to ask a question. Sometimes that takes a little effort I know.