trying to insert into access from a select menu using VB script

[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..

 

[Rieekan]

This looks more like a question for forum-329 instead of this one. This forum is used to talk about how to best design a site, and really doesn't delve into the server-side languages that make a site more dynamic.

- George

 

[ChrisHirst]

forum333 for ASP

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.