How to menu list restricted by 'a', 'b', etc.
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.