Go to record via Alpha

[stretch]

I would like to be able to navigate though my records via Alpha buttons (A-Z) and I have not been able to any script commands to do this. I can go to record #x but I am not sure how to go to record with customers names beginning with "C". I know that I can do a find to isolate the "C" customers but I would prefer to just "goto" said customers.

[-Queue-]

Create a relationship between a global text field and a calculation text field of Left( CustomerName, 1 ). Have the letter entered into the global and your script Go to Related Record [show, global_to_calc_relationship].

[Lee Smith]

Hi stretch,

I should have moved this post to a Topic area that is more representative of your question. But because this is your second try, I'll leave it here.

These three file, available at the URL's shown, demonstrate how this can be done.

AlphaJump By: Don Wieland URL:

http://www.fmfiles.com/tnt8.html

Alphabet Filter By: John Mark Osborne URL:

http://www.databasepros.com

AlphaDex By: The Alchemy Group URL:

http://www.alchemy-group.com/alchemy.html

HTH

Lee

[stretch]

Thanks Queue and Lee and sorry about the misplacement.

Cheers