How do I make the connection between typeId and typeName in detailsview edit mode

Vote count:

0

I have a detailsview with a sqlDataSource pointing towards the 'email' table. 'email' has a foreign key pointing towards another table 'emailType'. They are connected by the key 'typeId' and the 'emailType' table has a 'typeName' column. I retrieve the 'typeName' with the email table in my query, and I want it to be editable with a dropdown listing the different options under 'typeName', but I want it to change the ID. Sorry for the poor wording, I'll try to explain below.

I have two tables in a database.

Tables:

   email
        -typeId     **Foreign Key**
        -mxRecord
        -clientId
   emailType
        -typeId     **Primary Key**
        -typeName

The contents of the tables:

email
    typeId      mxRecord     clientId
       1          NULL           1
       3          NULL           2
       2          NULL           3

emailType
    typeId      typeName
       1        Exchange
       2          POP3
       3         Hosted

The detailsview in edit mode looks like this:

type       Exchange <-- How do I make this editable as a dropdown
                        and make it change the 'typeId' in the 'email' table?
mxRecord   NULL
clientId   1

asked 35 secs ago

Prokzy

1