Dynamic data entry

[Rufus Jackson]

I am not sure I am in the right place to ask this question. If not please direct me to the right place.

Situation: I have a field formatted to access a value list via a pop-up menu. The value list has several hundred entries sorted alphabetically. I have also opted for the "other" and "edit" options and they appear at the end of the value list. Since the list is so long, it takes a bit of time to access a value list item located at the lower end (or anywhere below the A's) of the value list as FMP scrolls from top to bottom.

Question: Is there any way to utilize dynamic data entry with a field of this sort? By dynamic data entry I mean by typing in the letter "R" for example FMP immediately goes to the portion of the value list starting with the letter "R". Typing "Ro" takes you even closer to your target, etc.

A secondary question: If there is no way to do the above, my next approach would be to resort the value list by most popular to least popular. Doing this would place those items most often used at the top of the list. So here is the question... Can a report be run to ascertain usage frequency in a given data field?

Thanks. Again if this needs to be posted in a different subject area please let me know.

[-Queue-]

Try using a list instead of a menu. Then typing the first letter will move you up or down the list to the appropriate section.