The following is a classic ASP-db example of using dropdown in filter and edit ->

Fk

<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="1;NWIND;orders;Both;;;;ACCESS;5"
X.dbNavigationItem="Top,bottom,next,prev,filter,ed it"
X.dbEditFlds = "0.1,2,3,4"
X.dbEditUpdateROFlds="0"
X.dbEditParams="Tablename=orders, bookmarkFlds=0"
X.dbFilterDropFlds="0,,Orders,OrderID"
X.dbEditDropFlds="2,,Employees,employeeid"
X.dbImageDir="/aspdb/images/"
X.ASPDB
%>