I don't see how your 2 letter sales rep code makes type ahead any more possible here.
You really do need to use the ID numbers as names are not always unique and may also need to be changed from time to time.
Here's demo file that includes an auto-complete enabled drop down list, but is script supported so that the related table's Primary key is the actual value entered into the field: http://www.4shared.com/file/plr_jbkk/EnhancedValueSelection.html
Ok, I understand. I was planning to make the rep code field unique, but I can see your point, I'm just tired of scripting every single thing!
So how do I get a value list to show only those account names that have a rep code (or a checkbox value called "is_rep" that is checked)?
This is called a "conditional value list".
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
Yes, I am aware of the conditional value list. Thanks again for the references.
What I can't seem to figure out is how to filter on (only show) a field that is "not empty".
There are a number of options. Here's just one possibility:
Define a calculation field constA in your main table to return the single letter "A".
Define this relationship:
MainTable::constA < ValuesTable::rep code
OK, thank you. I'll probably go that route.
What is the maximum number of items I can have in a pop up menu?
Also, what happens visually if there are too many to display? Does it show a scroll bar?
I don't know off hand as I try not to challenge my users with long lists in pop ups and drop downs without providing additional support to make them easier to work with. If you encounter issues with the number of values displayed, you probably should rethink your approach so that you can provide the user with a shorter list anyway. (That's one of the purposes of the enhance value selection files that I posted a download link to earlier in this thread.)