Selecting n records from a table into another table

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.

Ninox Profile

If you could give D and S data samples. And may be draft pic of what you gonna get...


Thanks, here it is.



Ninox Profile

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:


Students and Objectives table


Here you are evaluating levels


Qualifications table


And here is relations


Qualifications relations