0

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.

6 replies

null
    • Ivan_Savochenko
    • 4 yrs ago
    • Reported - view

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

    • preboredo
    • 4 yrs ago
    • Reported - view

    Thanks, here it is.

     

    Image

    • Ivan_Savochenko
    • 4 yrs ago
    • Reported - view

    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

    • writingz
    • RobertDuncan
    • 3 yrs ago
    • Reported - view

    Yes, that is the best solution suggested by previous user. I can manage my language school easily with this ninox. I manage students, monthly payments, invoices, book sales, receipts, taxes, debts, etc. 
    essayhave

    • oliviafrancis0990
    • 3 yrs ago
    • Reported - view

    Thanks for sharing the recommendation. I will definitely take this opportunity. I have time for such classes thanks to the best professionals http://essaysbank.com/essays who help to cope with any task

    • tim_kalkin
    • 2 yrs ago
    • Reported - view

    Thank you very much for this blog. I took a lot of interesting information for myself. I also write various blogs which I leave here https://essays-service.com/memo-writing.html I recommend!

Content aside

  • 2 yrs agoLast active
  • 6Replies
  • 1897Views