Selecting n records from a table into another table
P

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...

P

Thanks, here it is.

 

Image

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

Reply