sql help - asp application

[Mary Beth Faccioli]

Hi all,
I am developing a database driven web application
using ASP/IIS/Access where users (librarians) will be
inputting data (about instruction sessions) from a
form.  The database has several tables that populate
drop-down boxes on this form.  For example, there is a
table that lists different university departments and
is connected to the main table via a DeptID field. 

I am trying to use sql INSERT INTO in the form
processing but am having trouble figuring this out
because there are 5 tables to be joined when the user
submits the form.  Are there any good online resources
that would deal with this – I have seen some basic
things but nothing that deals with pulling together
this many tables.  I know this has to go on all the
time with database driven applications.  Can anyone
help?

Thanks in advance,

Mary Beth Faccioli
Web Specialist
Georgia State University Pullen Library
100 Decatur Street SE
Atlanta, GA 30303
404-463-9947
mbfaccioli at yahoo.com


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus – Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com