List by aplhabeth category

[rrb011270]

I have a db that has morethan 600 records and it has a field=name. I made a form called list that will list all the names in ascending alphabetical order from a~z.

My question is? how can I make a clickable alphabets in the Form:List like A~F, G~L, M~R, S~X and Y~Z.

When a user click this link it list only the names with beginning character of A~F (as example) and the rest of the alphabeth category.

I'd appreciate if somebody can help on how I can write the script on this matter.

TY

[Chuck]

Create a new field called FirstLetter that is a calc field with a text result. Set it to:

Left( name, 1 )

Here's the script for listing the records that begin with A-F:

Enter Find Mode[]

Set Field [ FirstLetter, "A..F" ]

Perform Find []

Chuck

[rrb011270]

thanx for d help...