I'm not sure how to design this part of my database but I can tell you how it will be on the front end part. Can someone help me with this?
The front end is going to look like this:
Depending which student is selected, the amount of tests can change, so student B could have Test 1-5 whereas student A has Test 1-3Code:Testing Information For student A | Time | Test 1 | Test 2 | Test 3 | | 8:00 | 3 | 5 | 2 | | 4:00 | 7 | 2 | 3 | | 2:00 | 4 | 5 | 1 | | 9:00 | 7 | 0 | 1 |
Does this make sense?
Basically, the table can expand both ways, there isn't a fixed amount of columns so I'm not sure how to record this or design it.