March 9, 201015 yr 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..
March 9, 201015 yr 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
March 9, 201015 yr M finds both Mike November and Lima Mike ==M* finds Mike November but not Lima Mike
March 9, 201015 yr 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.
March 9, 201015 yr 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
March 9, 201015 yr 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.
March 13, 201015 yr Author 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.
Create an account or sign in to comment