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

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



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


      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 






      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.