Alphabetical Buttons

[Keith Silva]

I want to use a set of alphabetical buttons (A,B,C. ...) to navigate through a list of contact people. I thought I'd seen an article about a good way to do this, but now I can't find it. Does anyone have any leads or suggestions?

Thanks, Keith Silva

[LiveOak]

For real speed, I'd use a relationship. Define the right side field as:

AlphaIndex (calc, text, indexed) =

Left(Trim(LastName), 1)

Define the left side field as:

gSearch (global, text)

Define a relationship called SelfByAlpha with gSearch <--> AlphaIndex

The script for each button is of the form:

Set Field (gSearch, "A")

Go to related record(SelfByAlpha, show only related records)

This will be MUCH faster than a find for large sets of records.

-bd

[This message has been edited by LiveOak (edited March 18, 2001).]

[Keith Silva]

LiveOak:

Thanks for the fast and detailed response. I understand the approach you have described and will work on it this week. Thanks again.

Regards, Keith Silva