Hi. I have a table D with a number of assessment criteria, each with an associated level; and I have a table S with names of students and their levels. I'd like to have a subtable in S that automatically displays all the relevant assessment criteria for the level of a given student.
If you could give D and S data samples. And may be draft pic of what you gonna get...
Thanks, here it is.
If I get it right you are trying to make a database to record students' levels on some objectives. It may look like this sample:
Here you are evaluating levels
And here is relations