how about 7 slots, 5 taken that leaves 2 empty....

[Himitsu]

I have a question that might not be doable.... I have a student list, class list, student line item and some others... on the student list, each kid can be assigned up to 2 classes (entering the "class id" that relates to the class list file). I made a column layout that I want to use for an attendance sheet. it is sorted by 1. day 2. class time 3. class id 4. student id's and Name's. I had to do it this way since we have more than one class at the same time. Now our max amount of kids in a class is 7. The classes that have less than seven, are able to handle "make-ups", that is, if one kid is absent one day, to make up the class he/she can come to another class for that absent day. So if a class has only 5 kids then 2 more can come for a make up. With that said, when I print up the attendence sheet (we will use this on paper so our office people can just put a check and put the make-up students in the box) the layout does what it is supposed to do, show 5 then go on to the next class. But what I want to know is would it be possible to have it add the remainder records (blank) for those two spots? I tried this with the classlist and had it done, but the problem is, when a student stops, it will still show them on the list. I don't want it to sort out the stopped and delete the records because I want to be able to see a kind of history of that class through out the year. I use the student list to sort out the stopped students. Ok, so then I tried to use the "line items" file. It will work, but again, when our new classes start next year, it will be a pain in the "#$ to perform finds and omits just so it will show the correct students for the current year. The student file, in my mind, looks to be the best file to use. What do you guys and gals think? Any ideas would be much appriciated.

[Kwaska]

Lets start form the point where it still works fine: it prints 5 kids and then goes to the next class. At this point I think it must be possible to change your program by adding some scripts (or scriptsteps) that do the following:

1. count the number of kids (=5)

2. Caculate how many blanc fields there should be (7-5=2)

3. Add new, blanc records (2 records), by either using a loop that adds one record till it reaches the calculated amount (2) or by having the number of kids count everytime a new record was added and leave the script when it reaches to 7

4. print the sheet with 7 records, of which 5 filled and 2 blanc

5. find the empty fields and delete them

does this help?