I have a portal in a contacts DB that I would like to display all records with the last name beginning with a, b, c, etc.

I have calculation filed which determines the first letter of the last name and scripts which sets a global field to specific letters. My portal is based on the relationship FirstLetter = :gFirstLetter

What I get is a mess...if I set gFirstLetter to A I get the name associated with the current record repeated the number of times there are A names.

What am I doing wrong? Do I need to create another file to handle this?

Thanks.

Your relationship needs to have the global field on the left side and the calculated first letter field on the right side. gFirstLetter <---> FirstLetter.

-bd