I am new to fileamke pro. I have a database with multiple tables two of them being a students table, and the other being a classes table.

I have these two tables being related to each other via section where each student is in a section 7A, 9B , 6C ect. The student table contains various information such as names addresses ect while the classes table containst information of various classes offered. In the classes table, there are fields for evaluation text and evaluation criteria. I have a layout which displays these and then the student name based of section.

The problem that i am running into, is that it will dispay the correct student whith the correct information for that section but only one student for each class, IE it will dispay one 6, 7, 8, and 9 grader but no more.

I hope that this make sence and thank you in advance

It's not clear what your structure is or how your class information is being displayed.

This thread discusses some structural ideas for a typical student-class system.

If your structure already looks like that, then displaying the class list from a Section table is just a matter of using a portal based on a relationship to Registration (a Student-Section join table).

Ok lets see if i can make it more simple.

I have a student table with a name and a section. I have a class table with a class name, description, and a section. The two tables are linked via the section.

Now, I have a layout that i would like to print the student name, section, and class description.

This is what is happening as i have it set up right now:

I have 54 students in sections that range from 6, 7, 8, or 9.

I have 16 Classes Math(6), Math (7), Math (8), Math (9), Science (6), Science (7), Science (8), Science (9), Humanities (6), Humanities (7), Humanities(8), Humanities (9), Computers (6), Computers (7), Computers (8), Computers (9)

If i have a portal in the student table linking to the class table it shows the correct class, however, this is not my problem.

If i have a layout with student name, section, and description, it will display ONE person in section 9 with the correct description, ONE person in section 8 with the correct description, ONE person in section 7 with the correct description, and ONE person in section 6 with the correct description for each class.

Now this makes since, because i am in the classes table and there are only 16 records in that table. However if i were to move the layout to the student table, then there would only be 54 records and each student would only display one class.

I am not sure if there is an easy way out of this. I am quite new to this.

Thanks in advance

Now this makes since, because i am in the classes table and there are only 16 records in that table. However if i were to move the layout to the student table, then there would only be 54 records and each student would only display one class.

So what is it you want to see here? A Student's course list or a Class's Student list?

Should a Student be able to have more than one Section? This is usually the case with High School classes, but your current structure does not allow for it.

This is what i want,

I want to pull the student names from the student table.

I want to pull the class name and description fron the class table.

I want this to corolate based on the section of the student.

I want this to display in a layout

What i was thinking, is that i could have a buffer table. In this buffer table would be a record with student ID and class ID.

Iam not sure if there is a way to do it without this but i will see

Thanks again