So I've been reading the forums and researching the web and my books and once again... stuck.
I am trying to design a page with a form in it that will have two pull down menus that are dynamically loaded from two seperate mysql tables automatically. The first pull down will pull from one mysql table. Once a value is choosen the second pull down should populate based on the selection of the previous pull down menu.
For example, if I select a company in pulldown menu 1 it would send info and pull projects that are owned by the pulldown 1 company from a second table and automatically populate pulldown menu 2 with projects.
Upon hitting the submit button the two values would be passed on and info from a third table with project journal entries will be listed.
Any insight into how to do this or suggestions on reference material that I may have overlook will be appreciated.
Chris