Two Or Three Tables To Relate This Excel File

[TaiChi56]

Not sure how to set up the tables for this EXCEL sheet. I was thinking of using a portal so when you go to a student's ID number or name it will show me everything that I have on the spreadsheet, his courses, the periods, the room number and the teacher all on one layout. How do I relate the table and can I do it with the way the EXCEL spreadsheet is setup. I have attached it.

Practice.zip

[Brent Durland]

Not sure how to set up the tables for this EXCEL sheet. I was thinking of using a portal so when you go to a student's ID number or name it will show me everything that I have on the spreadsheet, his courses, the periods, the room number and the teacher all on one layout. How do I relate the table and can I do it with the way the EXCEL spreadsheet is setup. I have attached it.

Typically in a database you'd have a table for each entity, and here you have at least two, student and course. So, one student record for John Wayne and one course record for E38. Then to track registration, you'd create another table that references both student and course. This is called a join table, and acts as a go-between so you can have many students registered for each course.

[TaiChi56]

Typically in a database you'd have a table for each entity, and here you have at least two, student and course. So, one student record for John Wayne and one course record for E38. Then to track registration, you'd create another table that references both student and course. This is called a join table, and acts as a go-between so you can have many students registered for each course.

Excellent, thank you I will work on that.

[TaiChi56]

Excellent, thank you I will work on that.

OK, I have worked on it and I am lost. I am attaching the database and the Excel spreadsheet so someone can inform me what I am doing wrong. I am trying to import the students schedule into the database. I am getting confused with the period column. Not sure how to bring in the students schedule and have it show as one form under that students name. When I do it, it brings in a whole bunch of records that I have to cycle through. Hope this makes sense.

Filemaker_ForumExample_Taichi56.zip

Student Record_Forum.zip