I need a little help with some ASP coding for a dynamic drop down menu. I would like to create a form where I can search for specific information in the database. I would like a drop down that displays specific fields that are in the database and which is automatically updated when the page reloads based on the information in the database. Now here's the tricky part, there can be duplicate entries with the same field, but I want the drop down to only show the field once. For example:<BR><BR>Date Range start: <input box><BR>Date Range end: <input box><BR>Acting supervisor: <drop down list><BR>Submit <button><BR><BR>Only the drop down list will need to update itself with all of the supervisors in the supervisor column of the database, but only display unique ones if there are duplicates. IE this would return all the records within a date range where the specified supervisor in the dropdown menu was the acting supervisor. If a supervisor is in multiple records, then their name would appear only once in the drop down list. And, if a new supervisor was added to a record in the database, it would automatically be updated in the drop down menu when the ASP page is refreshed.<BR><BR>Any help would be greatly appreciated.<BR><BR>Thanks.