Create related records
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:
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.