insert/select values against selection of combo box

[shah1419]

Dear all,
i want to insert obtain marks of the subjects.please find the attached my db for your kind review. when i select combo value my requirment is to insert the all records which associate with the combo. but when i select combo value it will happen nothing. pls see the required picture...also....


db1.zip

[rpeare]

I do not understand what you are asking. You only have one combo box on your form 'Test'. That combo box is a class. in the after update of that combo box you have some recordset cloning going on which I do not think you need.

What are you trying to accomplish.

Are you trying to bring up the grades for the listed student whenever someone changes the class?

Or are you trying to do something else?

Your database construction is not good which may also be hampering you.

You should have:
A table for your students
A table for the classes available (any class available at the school/temple/mosque)
A table that lists the classes a student took (holds the FK of the student table and the FK of the classes table and has a PK of it's own)
A table that stores the grades for each one of the tests taken in that class

this is at the very least.

Your structure is forcing each student to have one class only which I doubt is your intent.

[shah1419]

I do not understand what you are asking. You only have one combo box on your form 'Test'. That combo box is a class. in the after update of that combo box you have some recordset cloning going on which I do not think you need.

What are you trying to accomplish.

Are you trying to bring up the grades for the listed student whenever someone changes the class?

Or are you trying to do something else?

Your database construction is not good which may also be hampering you.

You should have:
A table for your students
A table for the classes available (any class available at the school/temple/mosque)
A table that lists the classes a student took (holds the FK of the student table and the FK of the classes table and has a PK of it's own)
A table that stores the grades for each one of the tests taken in that class

this is at the very least.

Your structure is forcing each student to have one class only which I doubt is your intent.

-----------------------
please help me to re design the datbase or send me the sample database ...

[rpeare]

wikipedia article about normalizing a database (there are literally millions of articles about normalizing databases out there)

https://en.wikipedia.org/wiki/Database_normalization