Something's off with my portal

[ruthcarlton]

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.

[LiveOak]

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