Page 1 of 1

PHP & MS Access List box form question

Posted: Thu Nov 20, 2008 10:14 am
by drkrnger07
I have an MS Access database that I have set up for class registration. My tables are set up as follows:

Class Information
ID (PK Auto Num)
Class_Name
Class_Date

Class_Registration
ID (PK Auto num)
Employee_Name
Department (list from a different table)
Extension
Class_Name
Class_Date

What I need to have set up is a form that the end users in our company can go to our intranet page and register for classes. I just can't figure out how to get the departments in a drop down list. I have attached how my form is supposed to look like.

The classes are programmed into the list box already. What I also need to do with the form, is when the user selects a class, I need the dates to update to the appropriate dates from the class from the database if that makes any sense. I'm kinda new to this so please bear with me. :banghead:

Any help is greatly appreciated!

Thanks so much!

Courtney