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:
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?