I have a job applicants table which is linked to a jobs available table via another table containing an id from both of these.

what I want is to be able to have a form containing the information from the applicants table and a drop down box or something similar to select a job from the other table and realte this to the job applicant, does that make sense?

Any help would be greatly appreciated,

tahnks in anticipation.

rob