I have successfully link web page to allow insert record into database at
back end (either SQL MDF or access MDB) using FormView in Visual Web

It is to get comments from users with these fields:-
Name
Dept
Your question

Say this is called Comment table

However this is not good enough.
I want Name and Dept are drop down lists and people can select their name
and dept from a separate source tables holding name and dept and these values
together with comments get saved.

Pls help how to get this done in Visual Web.