title: save FK value referencing a lookup table
body: <p>I have 2 tables: </p>
  
  <p>User (Id, Title_Value <strong>FK</strong>) </p>
  
  <p>Title (Value <strong>PK</strong>, Text) - This is a lookup table with fixed values (Mr, Ms, ...)</p>
  
  <p>then I have a form with the title bounded to a dropdown.</p>
  
  <p>what is the syntax to save the Title_value in the database? </p>
  
  <p>I tried this with no luck (the dropdown is passing the correct value):</p>
  
  <pre><code>User user = new User();
  user.Title.Value = Dropdown_Title.SelectedValue;
  </code></pre>
  
  <p>the error I get is the usual Object reference not set to an instance of an object.</p>
  
  <p>Thanks</p>