Hi,

I'm designing a website for creating appointments for doctors. I'm try to create a webpage where the user may select the name of a doctor with which they want an appointment from a dynamic dropdown list. Once selected the user must press the submit button to continue. My question is how can I cause a related record to the doctors name (doctor ID) to be inserted into a table in the database. Effectivly when a doctors name is selected the doctor ID should be automatically selected based on the name selected but it should not be visible and then when the submit button is pressed just the ID should be entered into a field in the database.

I'm not sure how to tackle this problem so help would be greatly appreciated.

I'm using Dreamweaver mx, ASPvb pages and an Access database.

Thanks in advance.