skula Posted August 11, 2011 Posted August 11, 2011 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.
comment Posted August 11, 2011 Posted August 11, 2011 Please do not double-post: http://fmforums.com/forum/topic/79615-need-help-with-relationship-logic-for-school-registration-database/
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now