Combo boxes

[CC801340]

Not sure if anyone can help me here or point me in the direction of a good website....

I want to design a page with two combo boxes. The first one obtains a list of "employer types" from a db. Depending on what the user choses in the first combo box, a second combo box then displays a list of "job types" - again from a db. There is then a submit button which will look at the two values in the combo box and return a "recommended wage" - if possible from a database.

What is the best way to go about this in terms of database design - is it necesary to have a different table for each job type?

I'm pretty clueless about where to start - a nudge in the right direction would be most apprecitated!

 

[Bastien]

table1
EmployerTypeID
EmployerType
EmployerDesc

table2
JobTypeID
JobType
JobTypeDesc
EmployerTypeID

should do it...then each employerID will can relate to each job type or multiple job types

hth

Bastien

There are many ways to skin this cat,
but it still tastes like chicken