I'm lost, someone help !

[Tradus]

Okay, this is what i try to do.

I have a database with contacts in multiple languages. I designed a few layout with standard letters on top of wich merge fields are positioned for greeting. The idea is to send a letter based on the language of the person with his name on top. For that I created a script but it doesn't work, i only get erratic results.

This is the script

GO to record (first)

loop

if ("language = "french")

Go to layout "Letter FR"

Print Setup

Print

Else

Go to record (End if last, Next)

End if

End loop

What am I doing wrong here? I tried to figure this out all night yesterday, but kept stuck on the same problems. Anyone could give me some help on this as i am fairly new to FM.

Thanks

Marc

[BobWeaver]

I assume that you only want to print letters for records whose language is french, and skip all other records.

Your script will not advance to the next record if the language = french. It will stay on the same record forever and print an infinite number of the same letter to the same person. Replace the 'Else' step with an 'End If' and delete the other 'End If'. Your script should probably look like this:

Go to layout "Letter FR"

GO to record (first)

loop

if ("language = "french")

Print Setup

Print

End If

Go to record (End if last, Next)

End loop

Go to Layout [original layout]

---

[Tradus]

Thanks for helping me out with this.

I'm goi,g to give it a try later today and hopefully it will perform as I expect.

Cheers !