2 Replies Latest reply on Feb 13, 2017 12:23 PM by SamOsman

    A to Z Customer Sort

    SamOsman

      Hi,

       

      I have a number of buttons on my layout from A to Z to sort a customer list by surname. e.g. Press 'S' button and only customers with the surname beginning with S show. I thought this was working fine, until I have some customers with a surname such as 'Smith Jones' So when the 'J' button is pressed it shows 'Smith Jones' I want it to only find by the first character of the surname field.

       

      Currently I have the following: Find Criteria R* for the letter R.

       

      How can this be adjusted to only search by the first character of the field?