PDA

View Full Version : PHP & MS Access


mstng06
11-11-2008, 08:07 PM
Here is my problem, I'm not sure if anyone can help, but I would greatly appreciate it. I have an access database set up for class registration, in which I need to set up a form for my company's intranet so users can sign up for training.

Here are my tables:

Class_Registration
ID (PK Auto Num)
Employee_Name
Department
Extension
Class_Name
Class_Date
Attended_Class

Class_Information
ID (PK Auto Num)
Class_Name
Class_Date

There will be a user to populate the class information table via form within the database. What I need to know is how to set up list boxes on a web form so that when a user selects a certain class (ie Word Training, Excel, Access) I can have a second list box or drop down that shows the appropriate dates for the specific class the user selects. I have been trying to set this up with PHP, but am not having much luck. I've tried searching on google, and to no avail. Any help would be greatly appreciated!

Thanks so much!