AnsweredAssumed Answered

Create related records

Question asked by d.b on Oct 5, 2010
Latest reply on Oct 12, 2010 by d.b

Title

Create related records

Post

Okay, I'm totally new to FM (and relational databases in general). This isn't as simple as I thought it might be.  I'm still getting comfortable with how to set up relationships correctly...

Anyway, I'm setting up a gradebook.  I have tables:

StudentInfo
Enrollment_StudentsAndClasses
Classes
Assignments
Scores

I'd like to be able to create a class set of records in the scores table after I create an assignment record.  The assignment table has info on which classes are related to the assignment, so I want it to in turn look to the enrollment_StudentsAndClasses table to identify which StudentID 's are enrolled in that class.  Then I want a record created in the scores table for each studentID.

I assume I need a script to do this unless there is a better set-up of tables or some FM tool that I don't understand.

Thanks for any help.

FMRelationships.jpg

Outcomes