Automatic adding records based on repeating field?

[ellastic]

Hello all, I'm a bit stuck...

I have a database of pupils and a related database of scorecards. Each pupil in my pupil database is related to a number of scorecards detailing their scores in a particular subject.

Since most pupils take the same basic subjects, I would like to have a script that automatically adds common scorecards. It needs also to check if they haven't already got a scorecard for that subject. I stored a list common subjects in a repeating field (perhaps a list is better?) and I want to be able to do something like this

Loop (for each subject){

If pupil doesn't already have score card for this subject{

Add new scorecard, set studentID and subject field

}

End Loop (when out of subjects)

Problem is I don't have a clue how to loop through the subjects... I'm sure it shouldn't be hard.

Ella

[transpower]

Use the GetRepetition (repeating_field, repetition) function.

[ellastic]

Thanks you! I feel silly! I still have limited knowledge of all the functions available so didn't know I could do that.

Thanks