Hi there, and thanks in advance,

I'm working in an Online Employment Application, and I have a Update page that updates the jobs that the applicants' applied for. But I'm having a problem adding the initial value from the INSERT with the dynamic list box's values from the UPDATE.

The main DB table "Employment_App" contains all of the applicant's information, including a column for the jobs they apply for. The secondary DB table "Jobs" contains detailed job information for each job.

After an applicant has initially inserted all of their Employment informtion, they're redirected to a main Update page. What I want is for there to be a dynamic list that contains all of the open jobs from the "Jobs" DB table, where an applicant can select one or more open jobs. When they click the Submit button, I want those selected Job_ID's from the secondary DB table "Jobs" to update the Job_ID column in the main DB table "Employment_App" in front of the initial value.

Example:
After the intial insert in the main DB table "Employment_App", the Job ID would be: 02-001

After the applicant selects more jobs with the Update page from the secondary DB table "Jobs", the Job ID would be: 02-001, 02-002, 02-003

I'm using SQL Server, Macromedia UltraDev4, ASP & JavaScript for this application. I've tried this solution:

<option value="<%=Session("Job_ID"%><%=(rs_App1A.Fields.Item("Job_ID".Value)%>><%=(rs_App1A.Fields.Item("Job_Title".Value)%>"</option>

...along with similar options, but it doesn't work. Any help would be greatly appreciated. Thanks.

kwilliams