I have a database for employees with different venues. In the Employees table I have empID which is an auto number. empID is in all of the venue tables as well. I have created a form that allows venue managers to see all the employees in the database whose venue ID matches their venue. From this page then can add these employees to the venue schedule page, but I cannot add the record to the venue table in the DB because the only way I seem to be able to read the empID into the form is with:
<input type="text" name="empID" value="<%=rsSchedules("empID")">
But of course the empID is not text so when the add_emp.asp pages tries to add the new record to the venue table I get a type mismatch error.
Is there an easier way to either call the empID into the form (I don't care if the venue manager sees the ID or not) or to convert it into the proper form so it can be added to the table?
I appreciate any help.
Edited by judo2000