I am using Filemaker Pro 10 to track registration for a "Monday school" that offers classes to homeschooled kids. We run for 5 hours, and kids take 5 classes (one per hour). I'm having trouble figuring out how to create a way to get FM to create roster lists. I am a novice at database relationships--I last used FM about 20 years ago when relationships weren't part of the picture, and so this is all new to me.

So here's where I'm at:

I have a table called "studentinfo" where I have student names and IDs, ages, addresses, etc. This also has a "schedule" area where I put down students' classes by hour (these fields are called "Hour 1", "Hour 2", and so on).

I have a second table called "classinfo" where I put down class ID (this is not a serialized number--I wanted to determine the ID for each class), class name, teacher name, time, and location of the class.

I have a third table called "rosterinfo" that is related to "classinfo" by Class ID (many to many), and to "studentinfo" by Class ID to Hour 1 AND Hour 2 AND Hour 3 AND Hour 4 AND Hour 5. (all many to many).

So here's my version of the diagram:

Table: Studentinfo Table: Rosterinfo Table: Classinfo

Hour 1 assignment > ---------

Hour 2 assignment > ---------

Hour 3 assignment > --------- < Class ID > --------- < Class ID

Hour 4 assignment > ---------

Hour 5 assignment > ---------

My layout for "rosterinfo" has the class ID and class name up top, and then a portal below that, which looks up student info such as names, ages, and parent contact info. I'm just trying to get a record for every class, and a list of all the students that are taking each class. But nothing is coming up in my portals, so I'm assuming my relationships are all wrong. I don't know how to tell Filemaker to do what I want it to do.

If you can help, that'd be great. Thanks in advance for suggestions.

Please do not double-post:

http://fmforums.com/forum/topic/79615-need-help-with-relationship-logic-for-school-registration-database/