Thanks Jason - I think I may have bitten off more than I can chew, but going to continue. I have made one slight change as follows to prevent entering one occupation and one location at a time, which will take so long it will defeat the object of automating it.
My tables now are:
Employer Table
Employer ID
EmployerName
EmployerContact
etc etc
Occupation Table
Occupation ID
Occupation
Salary
etc etc
EmployerOccupationJoin Table
EmployerOccID
EmployerID
OccID
Location1
Location2
Location3
Location4
Location5
Location6
The location fields are designed to be either yes or no. Firstly do you think this would work?
Secondly how is it best to bind data within a form. For example I would like to make the form user friendly so the person inputting the data can choose from the occupation description (which I have set up using ajax as you suggested), but what is actually entered is the OccupationID. Is this possible and if so how would I do about doing this?
