population

Question

Hi, Could I please get your thought on this issue please? There is a table in sql server which has about 20 million records. This table has an ID field called FileID. Currently on a web page there are two text boxes used for FrilIDfrom and FileIDto. This as you know means that the user has to enter the FileID values in the text boxes. I am thinking of using a drop down list instead of each text box. But the problem is it will take a long time for these drop downs to be populated for the FileIDfrom and FileIDto as there are over 20 Million records. What is the best solution for this please Thanks