Multiple records display on one DB

[jstrack]

I have two DBs. One contains classes That I teach. Each record has an ID# and description. My second DB lists my students and the classes (five) that they are scheduled to take.

My relationship is the Class ID# between the two DBs. I don't seem able to display multiple classes for a given student. I can select different classes however, only the first classes description appears in each of the five fields I ahv set for classes. Suggestions would be most welcomed. Thanks in advance.

[Chuck]

It sounds like you have a many-to-many relationship but have set up your files to have a one-to-many relationship. It's many-to-many because one class can have many students and one student can be in many classes. To make a many-to-many relationship work, you need to have a join file between the two files.

So, in addition to Classes and Students files you need a StudentsClasses file that is related to classes based on the Class ID and to students based on the Student ID. You also need to have Students related to StudentsClasses based on the Student ID and Classes related to StudentClasses based on the Class ID.

Once you have this set up, you'll be able to view all of the students in a class by using a portal to view the relationship from Classes to StudentClasses and you'll be able to view all of the classes a student has by using a portal to view the relationship from Students to StudentClasses.

Try a search on FileMaker's tech info database for many-to-many for some more information, or let me know if this wasn't clear.

Chuck