Excel To Database Relationship Layout

[TaiChi56]

I have an Excel spreadsheet that is converted from a PDF. I am trying to figure out how to get a student's schedule into their layout. When I import them one student ends up having 7records. Do I fix it with a portal or is it the way I have my tables set up. I am attaching the Excel file that shows one record, there are 2400 of them. I am looking at linking the tables as such.

Student (Table) Course-Section (table)

StudentID (Primary Key) StudentID (Foreign Key)

LastName

FirstName

Period (Not sure how to relate the periods)

I want to be able to input a studentID, the student's record comes up and I immediately see a layout like I see in my Excel spreadsheet without having to go to each record for each period. Hope this makes sense.

Practice.zip

[comment]

Isn't this the same question (and same file) as here?

http://fmforums.com/forum/index.php/topic/75219-two-or-three-tables-to-relate-this-excel-file/page__p__356218#entry356218

You have a one-to-many relationship between Students and Periods - so you need (at least) two tables. The data concerning the periods needs to be imported into the Periods table, along with StudentID. If the students being reported are not in the Students table already, then you also need to import them into the Students table. You can match on StudentID when doing this, to import only only new students.

[TaiChi56]

Isn't this the same question (and same file) as here?

http://fmforums.com/forum/index.php/topic/75219-two-or-three-tables-to-relate-this-excel-file/page__p__356218#entry356218

You have a one-to-many relationship between Students and Periods - so you need (at least) two tables. The data concerning the periods needs to be imported into the Periods table, along with StudentID. If the students being reported are not in the Students table already, then you also need to import them into the Students table. You can match on StudentID when doing this, to import only only new students.

Yes, it was, Sorry. I thought I was asking for something else. I am going to work on this and see what I can do.

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.

Student Record_Forum.zip

Filemaker_ForumExample_Taichi56.zip

[TaiChi56]

Ok, I was not sure if I should start a new topic or edit my last one. So if you look I posted a new one off of yesterday's answer. Sorry.

[Lee Smith]

Ok, I was not sure if I should start a new topic or edit my last one. So if you look I posted a new one off of yesterday's answer. Sorry.

Do not duplicate post your questions.

Go back an modify your other question, and I will delete this Thread.

Send me a Private Topic when you have finished.

Lee

[TaiChi56]

Do not duplicate post your questions.

Go back an modify your other question, and I will delete this Thread.

Send me a Private Topic when you have finished.

Lee

I modified the other post as instructed. I do not know how to send a private topic. I looked at the help files and it would not tell me. I tried sending a PM but you are not accepting new messages. Sorry, I really like this forum and don't want to screw it up. Hope you get this message and direct me to how to post a private topic. Thank you.