Is there a limit to the number of items a droplist can contain? I have a droplist on my search card so users can select a job number. The droplist is populated by a SQL query. When I run the query in SSMS, the result is correct (shows all my job numbers), but when I run the search card and click on the droplist, I do not get all of my job numbers.
Thanks for any help!