Hi, im running an asp script that takes textbox names and inserts the value entered in the textbox into certain tables in the database. Though i havent been successful in trying to find a method that works to do this, i assume joins will be needed?

so i have txt_fname, txt_lname, txt_job, txt_jobdesc, txt_stat

txt_fname and txt_lname which both need to be inserted into a staff table
txt_job and txt_jobdesc which both need to be inserted into a job table
txt_stat which needs to be inserted into a status table

I appreciate anyhelp Thank you.

probably best to ask this in the ASP section