trying to insert into access from a select menu

[Codeman0013]

Hey guys..

Here's what my delima is. I have 2 select menu's side by side and they work fine you can move one item from one to the other and thats what i want my problem comes into play where after you get the things into the left menu called CURRENTDEPT_ID how do i get them inserted into the data base. I have a field they need to go into and it needs go to by the departments_contact.DEPTCONTACT_ID and doctor_matrix_DEPTCONTACT_ID this data needs to go into the dr matrix table and check if there is anything there and if there is a record delete it and add a new one based on that DEPTCONTACT_ID and also if the user leaves the list blank it needs to go into the database in the doctor_matrix table and delete all instances with the DOC id the url is passing into the code. Also on another page i have an add section with the same thing how do i take the values and insert them into the doctor_matrix table based on what ones they put into the left menu

please help me i'm lost and have no idea where to go to next in this process!!!



Remember free things are fun but they can come with an emotional price tags..

 

[Sheco]

You can use ActiveX Data Objects (ADO) to do database interactions from your Active Server Pages.

Check the FAQs for this forum for lots of examples:

http://www.tek-tips.com/faq.cfm?pid=333