I want to create an A-Z navigation bar that will allow users to "jump to" a record in the found set, based on the first letter of the <> field. The purpose of the nav bar is so that users can avoid scrolling through lots of records, or typing in criteria for finds. I envision it looking like this: A | B | C | D |... |XYZ, with each letter as a button/script. When the user clicks on "C" I want the script to sort the found set in alpha order and then make the active record the first record in the found set that begins with the letter "C".

I should be able to write the script, but I can't figure out the calculation to move to a different record in the found set.

Is anyone using a nav bar like this?

See if this post helps

Ok I just re-read this post. I misread a part of it. What you are trying to do can be done. Read the thread that I pointed out to you.

As it states, create the stored calculation key to get the starting letter for each record.

Then create a global text field and create a self joining relationship from this field to the calc field.

Then your script that your buttons call could pass the script parameter as the other post stated. However, rather than doing a find, you will set the global field, sort step, and then do a Go to Related Record step.

for you XYZ, the set field would be

Set field [gLetter; X ¶ Y ¶ Z ]