I've done a script which is supposed to exclude some of my records but it doesn't work properly, what am I doing wrong?

(I'm using a swedish version so I don't know if I translate the steps correctly)

Go to layout (year)

Sort records (no dialog)

Go to record (first)

Loop

If (Year::user "overwritten =" global::user)

hide record

End if

Go to next record (exit after last)

End Loop

Go to layout (month)

Sort records (no dialog)

Go to record (first)

Loop

If (month::user "overwritten =" global::user)

hide record

End if

Go to next record (exit after last)

End Loop

The relation to the table "global" is an "open one", everything gets through.

When I perform this script, only some of the records with not matching user gets hidden. I have to perform it 3 times to get all the records hidden. Since I start at the first record and goes to the last I don't understand why all the not matching records gets hidden the first time

I assume the "hide record" step is the equivilent of "Omit Record" in English FMP versions.

If a record is omitted the next record automatically becomes selected, there is no need to issue a Go To Next Record step.

Loop

  If (Year::user "overwritten =" global::user)

    hide record

  Else

    Go to next record (exit after last)

  End if

End Loop

Thanks!!

When somebody else explains it seems so simple.

Now it works splendid