Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Basic portal question


This topic is 4852 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

This topic is 4852 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.