Hi there,
I've 3 tables (tbl_all, tbl_students, and tbl_tests)
I want a database to check if the students have done their Tests.
The amount in tbl_students shows how often the students have to do their Tests per year.
So my Goal is to create a form where I can select the Student and the test and it's automatic creates as many data sets as the amount is. Like amount(year) it'll create 1 data set. If it's quarter it'll create 4 data sets and if it's Monthly it'll create 12.
The Date should be year(01/01/2019), Quarter(01/01/2019,01/03/2019,01/06/2019,....) and Monthly (01/01/2019,01/02/2019,....).
Is this possible ?
best regards
Georg
I've 3 tables (tbl_all, tbl_students, and tbl_tests)
I want a database to check if the students have done their Tests.
The amount in tbl_students shows how often the students have to do their Tests per year.
So my Goal is to create a form where I can select the Student and the test and it's automatic creates as many data sets as the amount is. Like amount(year) it'll create 1 data set. If it's quarter it'll create 4 data sets and if it's Monthly it'll create 12.
The Date should be year(01/01/2019), Quarter(01/01/2019,01/03/2019,01/06/2019,....) and Monthly (01/01/2019,01/02/2019,....).
Is this possible ?
best regards
Georg