locked
Updating a linked table? RRS feed

  • Question

  •  

    Hello

    I have an SQL 2005 Express table with the fields DocID (Unique), DocTitle, DocPath and DocSubmitter.

    I am using a Web Form to insert records, I can do the Title (textbox) and Path (FileUpload) no problem.

    The submitter is linked via a submitterID relationship to another table, submitters. So it will be expecting a number (1-30) not a name as listed in a dropdown list on the web form.

    How do I update this field???

    Thanks, Mark

    Monday, September 4, 2006 10:31 PM

Answers

  • Although this is not related to SQL Server forums, you will have to define both the Label of the combobox and the Value. These are two different properties. The Label will be displayed and the values will be posted when the action of the form executes.

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Tuesday, September 5, 2006 9:45 AM