Help

How to convert each row into a new table?

163 1
cancel
Showing results for 
Search instead for 
Did you mean: 
FPK
4 - Data Explorer
4 - Data Explorer

I'm building a database for students in college. So the main table has Student ID, Name, Course 1, Course 2, Course 3, and so on, up to the highest number of courses a student is taking. I then want to create individual tables for each row in the main table in which I could report on student's progress in their respective courses each semester. Eventually, I want a reporting table with progress updates from all students that I can sort using semesters to report on students' progress in different semesters.

I thought this should be the easiest thing to do but I have not been able to accomplish it. Can anyone point me to a guide or explain the main steps to do so. What are the limitations to this approach and is there a better way to do so?

1 Reply 1

Hm if I were you I'd have three tables instead:
1. Students
2. Courses
3. Students <> Courses

This'll let you track the progress of each student's progress for each course

Screenshot 2025-01-26 at 12.14.26 PM.png

Screenshot 2025-01-26 at 12.14.24 PM.png

Screenshot 2025-01-26 at 12.14.22 PM.png

Link to base