AnsweredAssumed Answered

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

Question asked by macamaca on Jan 17, 2010
Latest reply on Mar 30, 2010 by philmodjunk

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. 

Outcomes