11 Replies Latest reply on Mar 30, 2010 4:10 PM by philmodjunk

    How to menu list restricted by 'a', 'b', etc.

    macamaca

      Title

      How to menu list restricted by 'a', 'b', etc.

      Post

      Hi all.

       

      I have a database that has a find screen with a pop-up menu containing text generated from the records and sorted.

      Trouble is this list is too long (650 items) for a pop-up menu.

      So I want to split it up by alphabet to show only those beginning with "a..." and another with "b....", etc. 

       

      For example pop-up menu "A" should only show 

       aardvark

       abseiling

       advancement

       etc. 

       

      Even though the record(s) with those items also have other terms (beginning with other letters) in a free text field.

      However all items are on a line separated by a paragraph return. 

       

      Sorry if I have not explained this very well, but am hoping someone can help.