What kind of Find.. will put me at the first record of a,b,c etc?

[RodM]

What kind of Find.. will put me at the first record of a,b,c etc?

My idea,

I have a 26 hot spot button... if I click on M, i go to m in the records..

[Fitch]

Did you try "M*" (no quotes)?

[Lee Smith]

You need a calculation field;

FirstLetter; (calc, text) =

Left([color:blue]yourfield; 1)

Your script should look like this;

Find File Alpha

Set Error Capture [ On ]

Set Variable [ $letter; Value:Get ( ScriptParameter ) ]

Enter Find Mode [ ]

Set Field [ [color:blue]yourfile::FirstLetter; $letter //This is the first letter of your FirstLetter ]

Perform Find [ ] Sort Records [ Specified Sort Order: ascending ]

[ Restore; No dialog ] Go to Record/Request/Page

[ First ] If [ Get (LastError) <> 0 ]

Show Custom Dialog [ Title: "Warning"; Message: "No records found."; Buttons: “OK” ]

Show All Records End If

Each button will have a script parameter of the Letter the button represents i.e. G = "G" parameter.

HTH

Lee

[comment]

M finds both Mike November and Lima Mike

==M* finds Mike November but not Lima Mike

[Fitch]

Without much to go on, I imagined this was targeting a Last Name field, and kept it simple. But a last name might be more than one word, you're right, "==" is more likely to be what is wanted here.

[Lee Smith]

The OP's stated

I have a 26 hot spot button... if I click on M

which doesn't sound like a Manual Find to me, but more like Link

[Fitch]

In general I prefer to work with lists rather than filtered portals. The Find would be scripted, not manual -- that's sort of implied when we're talking about buttons.

[Lee Smith]

Maybe it is time for the OP to reply to what has been suggested?

[RodM]

Thanks for your comments... When i can't figure it, I ask question, this on a learning exercise.. since then i decided not to do so and just let the op use the scrollbar

I think ==M* seems simpler and get my record point to the fist letter of the name field.