I am developing an employee database (MS Access 2000) and have a problem.

I have several table linked to the main employees

table. What I would like to do is list all values from one

table in a drop down via an asp page and allow an administrator to

update these values.



For example, when you view an individual emplyee record, a drop-down

should list all the available departments from the departments table

and the current department for the employee should be selected.



I have a departmentID in the employees table.



Thank You

I am developing an employee database (MS Access 2000) and have a problem.

I have several tables (departments, offices, levels etc.)and one main 

employees table. What I would like to do is list all values from one table 

in a drop down via an asp page and allow an administrator to update these 

values.



For example, when you view an individual employee record, a drop-down

should list all the available departments from the departments table

and the current department for the employee should be selected. An admin

should then be able to change this if necessary and they would see the

changes as the new department would be selected in the drop-down box.



Two of the tables I have in the db are:



Departments

-----------

departmenttid autonumber (primary key)

department text



Employees

---------

employeedid autonumber (primary key)

departmentid number



Thank You



_________________________________________________________________

Get your FREE download of MSN Explorer at http://explorer.msn.com