Trouble distributing records

[SES Tech]

With a script, I'm trying to cycle through external class records and distribute them to three tables based on Grade. The external records populate find and I create new records OK, but they are empty. Attached is a sample file. Can anyone help? Thanks

SMSScheduling.zip

[transpower]

Not all files are in your attachment.

[SES Tech]

True - the external file is enormous. Is it absolutely essential. Maybe I could slim it down.

[ESpringer]

Even without the file, I'd venture a conceptual question, though: Why would you want and need to distribute structurally similar records to three separate tables rather than to one table with a field to mark their different status? Especially in FM7 with multiple match criteria, you can use relations to "get at" any sort of subset data quite neatly...

[SES Tech]

I was trying to create value lists of courses, but limiting them to each grade: 6,7,8. I see what I did wrong. I was imagining I could create records in tables. Actually, the external file containing classes has many records - 3 grades and 8 blocks of time. I want to show a drop down for each block of only the ligitamate classes. I wish FM had VBA

[ESpringer]

You can make a value list on any relation, and relations can filter records according to complex match criteria. Although I don't know anything about VBA, I'm confident that what you're trying to do here shouldn't need extra tables or anything beyond a carefully constructed relation.

Suppose that you have a record for a student, and that student record includes a field for current grade (perhaps a calc based on projected year of graduation). Suppose all the courses are in one table, which includes a grade field. Then, you can create a relation between each student and all of the courses available to that student, using the grade field as the match key. A value list can be built on that relation, so that from within the student record, one could see a drop-down value list of all the courses appropriate to that student's grade.

It sounds like you might actually want to have yet another table of "ClassAssignments" where each record represents ONE student's being IN a class AT at time slot. You could have portals from each student's record to the class assignment for each specfic time block; and each portal's class assignment field could show a drop-down list of courses that are appropriate FOR the student's grade AND avaliable during the time slot in question...

Is it something like that you want to do? Keep telling us the particulars of the functionality you want to achieve. Perhaps it doesn't have to be very difficult!

[SES Tech]

Thank you. Here goes. My main table (in another file) contains student records with fields for each time slot M-F. My Classes table (also remote) contains a listing of all courses and their M-F time slots. There are some 30-40 valid classes. The layout I want to construct will be an individual schedule for the student. To assign a class I want to be able to click in a time slot and see a Popup menu listing the available classes for that time slot and the students grade (6-8). Does this make sense?

[SES Tech]

I've created a new example file showing a couple of fictious students but real classes. The main layout is a schedule. In the first block of Monday, I have a drop down list of classes. What I want is to show only the classes from the grade (6) and the block (Block 1). There should be only 3. Similar with each of the other fields. Basically, I want to restrict the choice to those available. We are Monday schedule based, but the Classes record shows where else the class is scheduled.

The student records are currently filled in by an external Visual Basic program because I couldn't figure out how to do it in FM. Thanks

TestScheduling.zip