storing student module records

Hi all, i am setting up a database using sql to store details for students modules results, i have 3 tables

students
modules
results

the issue is i cant understand how to store data in the results table, as students have completed many modules, how would i store this?

re: storing student module records

Hi.

How are your tables structured?
What exactly do you mean by "module"?

Assuming that it is something like a class or a course the student has completed and been graded on, and you need that grade stored in your result table; the typical structure for such a system would be to have a Student table with a unique ID for each student, a Module table with a unique ID for each module, and the result table, which would reference the ID's of both the Student and Module tables along with the grade.

re: storing student module records

In the results table i want to store data of students who have completed Xnumber of modules(subjects)..

re: storing student module records

But that information would be available from the modules table only. Why do you need the results table? Do post your table structures so we can understand what you are trying to get at.