Multi-select Dropdown Box

[EmmaGale]

ASP/VBScript

Please can someone help me before i tear all my hair out! I have spent all morning trying to find some help on writing the data from a multi-select dropdown box to an access table.

The table (Resistences) I want the multi-drop box to write to consists of three fields:
ID(Autonumber)
PatientID(foreign key from other table)
Resistence_Type

The multi-select box is within a form which contains other input boxes and the data from these boxes will be saved to the main table. The foreign key on the corresponds with the Autonumber on the main table.

I have two problemes - i am using dreamweaver and need to fiddle with the code which should allow two recordsets being able to write to the database at the same time. I think i have found a solution to this part!

However, the main problem is getting the dropdown box which can have more than one selection to correctly write to the resistence table.

I hope this makes sense. Thaking you all in anticipation.

Kind regards
Emma Gale