title: Asp.Net, Dynamic Data Website, Foreign key One to One relationship, DropdownList, how to customise?
body: <p>I'm using Asp.Net's Dynamic Data Website project type.
  I've created a db that has one to onerelationship between two tables specified using a foreign key, (this could be one to many but I've used the linq designer to change it to a one to one relationship).</p>
  
  <p>i.e. I have a table Invoice and table CreditNote that takes an Invoice_Id as a foreign key</p>
  
  <p>I was hoping that when I navigated to CreditNotes/Insert.aspx that it would display the a list of InvoiceIds in a dropdown list. It almost does this - it creates dropdownlist but only populates option value and not the text so I get something like this in the html source (notice only the value is populated - which looks empty to the user):</p>
  
  <pre><code>&lt;select&gt;
      &lt;option value="someInvoiceId"&gt;&lt;/option&gt;
      &lt;option value="someInvoiceId"&gt;&lt;/option&gt;
    &lt;/select&gt;
  </code></pre>
  
  <p>Can anyone tell me how I could fix this?
  Thanks in advance for any help!</p>