This was addressed in another topic but it was a little different and I didn't really understand the answers anyway.
I have a web form that puts information tinto a table called employees.  I want to create a form that people can use from different venue can use to assign employees from the employees database to their venue database.  For example the JoyBurns(ice arena) table pulls emID (employeeID) from the employees table with a drop down menus.  So I can go to the database and open JoyBurns table and select an employee from a drop down menu which is populated from the employees menue.  What I can't figure out is how to get that drop down menu from the Joy Burns table into a web form so venue managers don't have to go into the database.  Any help will be greatly appreciated.

Thanks

<%
'Create  DSN Less connection to Access Database
'Create DBConnection Object
Set DBConnection = Server.CreateObject("adodb.connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.Mappath("/path_to_your/database.mdb")
DBConnection.Open DSN

'Count the Records

   SQLcount = "Select * From table"
      Set RS = DBConnection.Execute(SQLcount)

 Select Case RS.eof
      Case False
        tempRSCount = RS.getrows
        Set RS = Nothing
        count = Cdbl(UBound(tempRSCount, 2)) + 1
               
     Case True
      count = "0"
 End Select
     Set RS = Nothing
 

%>

         <select size="1" name="dropdown_name">
         <option value="choice 1">Pick one</option>

         <%
         IF count > 0 Then
      
'Display records

    
  SQL = "Select * From table"
      Set RS = DBConnection.Execute(SQL)
            
        rs.move idc
      
        while not rs.eof
         data1 = rs("data1")
         data2= rs("data2")
         idc = idc + 1
         %> 
         <option value="<%=data1%>"><%=data2%></option>
         <%
         
         rs.Movenext
        wend
       Else
       %>
       
         <option>no data to display</option><%
       End IF
  %>

Replace everything in red with your own data.