Select From Dropdown and Create Form

[VictorValdez]

I am creating a jobs database for our HR department and I would like to have the person inputting data to select either 'Classified' or 'Professional'.

Upon selecting either from a dropdown menu, I would like the page to post the form for either position. I have to separate forms because there are very different requirements to be entered for the jobs.

Am I going about this right way or should my database contain one table for both Class/Prof instead of two?

FYI...Using Macromedia Dreamweaver MX to connect to MySQL DB using PHP.

Such a n00b. Thanks for any help.

[djoseph74]

Personally, I'd use one, and then have a column in there for the type it is. It's just easier... You can easily filter 'em in a SQL query by doing something like:

SELECT * FROM table WHERE type = 'sometype'

-Dan Joseph

[VictorValdez]

Many Thanks for your suggestion. I did create one Database table and 2 pages with 2 recordsets from that table (one for class and one for prof). Seems to be working quite well.

Thanks again.